Turning a name and address into soundex codes

[Mike Schwartz (PC Support)]

> -----Original Message-----
> From: Nancy Palmquist [mailto:nlp at vss3.com]
> 
> Mike Schwartz wrote:
> >      I'm working on a process to turn a name and address list into
> > soundex codes.  (filePro 5.0.14 on SCO Unix).
> >
> >      I'm trying to figure out all the in's and outs for parsing a name,
> > such as "The Bill Smith Company".  I'm creating a separate filePro file
> > names custSoundex with a many-to-one lookup to the customer file and
> > creating separate Soundex records for "Bill" and "Smith" , skipping
> > words like "the" and company".
> >
> >      I want to do this for the two street address lines and the city
> > name, too.  Has anybody else taken a different approach, other than the
> > separate Soundex file concept?
> >
> >      Rather than reinvent the wheel, does anybody have any code that
> > they would share/sell that already does something like this?
> 
> What about Associated fields in the file with the stuff you want to
> soundex?
> 
> For example:
> 
> F1) Soundex1
> F1) Soundex2
> F1) Soundex3
> 
> ...  for as many as you need make the length appropriate for the soundex
> edit (6 or 8 or something like that - I don't remember)
> 
> Build the index on F1)
> 
> Just do your parsing and put data in each field from logic
> 
> That should put you right at a real record.  Saves the need for another
> file.
> 
> Nancy

     Your idea has merit, but I don't want to add a lot of fields to the
existing customer master record.  

Thanks,

Mike