Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Name clean up routine
Message
From
05/09/2006 12:07:50
 
 
To
05/09/2006 08:14:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01150621
Message ID:
01150979
Views:
17
That was my point. But the :-( may not have expressed it very clearly <s>


>List or probable first/last names is problematic, as many names can be both ... Dennis, Mitchell, Paul, John, Lee, Nelson, James, and the list goes on and on.
>
>It gets much worse when your list includes nationalities where the family name comes first.
>
>>>Does anyone have a routine to clean up names for mailing?
>>>
>>>I have names like 'SMITH E ROBBIE & JONES REBECCA L' would like it to read 'Robbie Smith & Rebecca Jones' or something similar. does anyone have a routine written to clean up names?
>>>
>>
>>PROPER() would do a bit of it. The rest would require (as a starting point) a database of probable first and last names :-(
Previous
Reply
Map
View

Click here to load this message in the networking platform