Turning a name and address into soundex codes

Mike Schwartz mike.appleton.wi at sbcglobal.net
Thu Oct 5 08:17:02 PDT 2006


     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?

 

Thanks!

 

Mike Schwartz

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20061005/4c4b4b1c/attachment.html


More information about the Filepro-list mailing list