Reported Post by naimish
has reported a post.
Post: How to parse out name from Excel spreadsheet
Forum: Introduce yourself
Assigned Moderators: SaswatPadhi
Posted by: kdr1178
I have a question of how to parse a name from an excel spreadsheet. You see we have multiple spreadsheets and we need to seperate out each piece of the name to import into an Oracle database. Our fields in the database are the PREFIX, FNAME, MNAME, LNAME, SUFFIX. Here are some examples of what type of data we are working with: Lt. Jerry Goodman
Paul F. Clark, II
Any help with this will be really appreciated!!