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

[sconnolly019]

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.

[DavidP · Accepted solution]

How about this?

[mifrahm]

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

[JoeL]

Does this help?