Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Name parcer???
Message
De
10/04/2013 10:35:18
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01570274
Message ID:
01570602
Vues:
58
J'aime (1)
>>I have a bunch of data that has people's name all squeezed into one field like
>>Smith, John, D Jr
>>
>>..and I need to of course put it in 3 fields (first name, middle name, last name) - anyone got anything like that?
>
>I have attached a classlibrary called sdsstrings which may do the parsing you require.
>
>I have no idea who wrote this library otherwise I would definitely give credit.
>
>This is how I use it:
>
>loNameParser=NEWOBJECT('utlnames','sdsstrings')
>loNameParser.setformatnames_on()
>
>m.fullname=source.fullname
>m.first=loNameParser.returnfirstname(m.fullname)
>m.middlename=loNameParser.returnmiddlename(m.fullname)
>m.last=loNameParser.returnlastname(m.fullname)
>m.suffix=loNameParser.returnsuffix(m.fullname)
>
>
That looks like Steve Dingle's stuff which I emailed to Victor last night. SDS was short for Steve Dingle Solutions I think.
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform