How to parse out name from Excel spreadsheet

kdr1178's Avatar, Join Date: Sep 2009
Newbie Member
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!!
kdr1178's Avatar, Join Date: Sep 2009
Newbie Member
Can anybody help me?
naimish's Avatar
Banned
Yup, If you please look the topic of forum before posting it. You posted it in Introduction topic.
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Moved
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
Quote:
Originally Posted by kdr1178 View Post
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!!
Do you mean that each piece of name is separated with space?
If yes than that would be simple.
RandiR's Avatar, Join Date: Mar 2009
Light Poster
I am not sure I understand the problem, other than that you want to do "something" with a spreadsheet. (I apologize if I am not understanding that correctly.) One of these scripts may help - biterscripting.com/samples_data.html .

Randi