Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Name clean up routine
Message
 
 
À
05/09/2006 08:14:34
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01150621
Message ID:
01150902
Vues:
24
In our algoritm we had a switch which allowed to indicate if the first name comes first or second. E.g. in Lee Nelson it could be either way, but usually the whole file uses one pattern and a human eye can recognise it.

>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 :-(
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform