[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!!

[kdr1178]

Can anybody help me?

[naimish]

Yup, If you please look the topic of forum before posting it. You posted it in Introduction topic.

[shabbir]

Moved

[nimesh]

Quote:

Originally 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!!

Do you mean that each piece of name is separated with space?
If yes than that would be simple.

[RandiR]

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