Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

sconnolly019
5 - Atom

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.

 

3 REPLIES 3
DavidP
17 - Castor
17 - Castor

How about this?

 

regex.png

mifrahm
8 - Asteroid

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
Alteryx
Alteryx

Does this help?

 

Parse First Name Last Name Workflow.png

Labels