Parsing Names - First Name, Middle Initial/Name, Last Name (multi word names)

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.

Regex

Accepted answers

How about this?

All comments

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.)

Does this help?

Parse First Name Last Name Workflow.png

Name Parse RegEx.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703