I am looking for some help on a name parsing issue. I have read all of the other threads about this, but couldn't find a solution to my particular set of names. The previous threads only addressed basic structure names.
Solved Name Style: John S Smith. Solved using RegEx.
Unsolved Style: Jose L De La Cruz.
I cannot figure out an efficient way to parse these names. My end goal is to have them in this format: Smith,John S. However, just some help to split them into the 3 name groups would be very helpful.
Does anyone have suggestions?
Thanks.
Solved! Go to Solution.
How about this?
I am facing a similar issue. For a names in a list such as
JOHN_1234
JOE_1234
JORG_12345
NO EMPLOYEE
JOHN SMITH
JOHN A SMITH
JOHN ABC-SMITH
JOHN ABC SMITH
that I want to join with names in a list that includes no middle intials.
So John A Smith = John Smith . Does this make sense?
When I try to parse it ends up neglecting others that have a - in the last name + employee IDs with numbers (JOE_1234 for ex.)