Parsing Names - First Name, Middle Initial/Name, Last Name (multi word names)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How about this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
