[resolved] Input has full name field - How to split into FirstName, LastName, etc
My input data has only a FullName field. Is there a tool in to parse the field into separate FirstName, LastName, etc. fields?
The input looks like this: "Firstname Middlename Lastname", where the Middlename can be an initial, a full middle name, a maiden name, or not present. Lastnames can be hyphenated. No prefixes, suffixes, but it would be great to handle those, too.
Is there any tool or technique that can parse a more complex combined-name field (such as: Mr. John J. Jones Jr.) into fine-grained fields (such as Prefix, FN, MN, LN, Suffix)? I'll probably get sources like this in the future.
There is no a function can handle such kind of combined-name field, if the field is regular, I think you can create a custom routine to parse it, and call the routine in the job.
Shong
