Turning a name and address into soundex codes

[Nancy Palmquist]

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

-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com