>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)
Brandon Harker
Sebae Data Solutions