Help on name parser

  • Thread starter Thread starter Joel Claros Curiano
  • Start date Start date
J

Joel Claros Curiano

We have excel data in one cell that is formatted like this: Curiano,
Joel Jr. Claros (LastName, FirstName Suffix MiddleName)

How can I extract each of the elements of the name and put them in each
field so that Curiano is put into the LastName field, Joel goes into the
FirstName field...

Thanks
 
Have you looked into using Excel to do the initial parsing?

If your data is already in Access, look up the Split() function (depends on
which version you have) to break the string apart at some common symbol
(e.g., the space " "). Note that this will not be completely foolproof, as
concatenated names (Mendes y Garcia) and names with multiple pieces (van der
Wallis) will be "split" also.

In the end, you'll probably need to do what ever parsing you can with Access
or Excel, then rely on USB (using someone's brain) to review/correct.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Joel said:
We have excel data in one cell that is formatted like this: Curiano,
Joel Jr. Claros (LastName, FirstName Suffix MiddleName)

How can I extract each of the elements of the name and put them in
each field so that Curiano is put into the LastName field, Joel goes
into the FirstName field...

Thanks
Click to expand...

Have you imported data from Excel spreadsheet into Access the database?
If not you need to post your question to an Excel newsgroup as this is an
Access database newsgroup.

You only posted one example. It would not be difficult to work with
just that one example, but I suspect your data may not all have the same
name or format. For example.

Joseph E. Meehan
Curiano, Joel Jr. Claros
Curiano Joel Jr. Claros
Curiano, J. Jr. Claros
Curiano, Joel Jr Claros
Curiano, Joel Claros
Curiano Jr. Claros
etc.

How consistent is your data?
 
The names are consistently formatted this way: Curiano, Joel Jr. Claros
(Surname, FirstName Suffix MiddleName). I am going to use the data in an
Access app and would like to get the flexibility of separated data.

I know it can be done programmatically and I was hoping to get a clue on
how to do it best. I'll try the split() function that Jeff suggests and
go on from there.

Thanks.
 
Back
Top