Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Name parcer???
Message
From
10/04/2013 10:35:18
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01570274
Message ID:
01570602
Views:
59
Likes (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
Previous
Reply
Map
View

Click here to load this message in the networking platform