Parse Full Name into First, Middle, Last name with Suffix

Hello have been trying to find the answer to this but cant seem to get a full breakdown i found some that can do half of what i need.

I'm looking to take a column with the full name and break it down into First name, Middle initial, Last Name, and Suffix. Also some last names have a hyphen in the last name and some names have a middle initial and some don't.

Was wondering if there is a regex code that can parse the full name and break it down. i posted a table example below....

Any help would be greatly appreciated

This is the original column....

Full Name

Anthony Smith

Ava R Collins

Carol Smith-Rodriguez

Jennifer Jones

Jeff G Waller JR.

Frank Hobbs

Tom Griffen SR.

Alicia F Smith-Walker

Would like the below output ....

Full Name	First Name	Middle Initial	Last Name	Suffix
Anthony Smith	Anthony		Smith
Ava R Collins	Ava	R	Collins
Carol Smith-Rodriguez	Carol		Smith-Rodriguez
Jennifer Jones	Jennifer		Jones
Jeff G Waller JR.	Jeff	G	Waller	JR.
Frank Hobbs	Frank		Hobbs
Tom Griffen SR.	Tom		Griffen	SR.
Alicia F Smith-Walker	Alicia	F	Smith-Walker

Datasets

Regex

Output

Parse

Common Use Cases

Best Practices

Help

Accepted answers

binu_acs

@Nmassarone

NameSplit.yxmd

All comments

Alteryx_AR

@Nmassarone You can use text to column tool with space as a delimiter.

Then to rename fields use select tool

Hope this helps you 😊

Nmassarone

so i tried that but the only thing with that is it doesn't align everything into the correct columns because some names don't have a middle initial and some dont have a suffix so it would output like this ....

First Name	Middle Initial	Last Name	Suffix
Anthony	Smith
Ava	R	Collins
Carol	Smith-Rodriguez
Jennifer	Jones
Jeff	G	Waller	JR.
Frank	Hobbs
Tom	Griffen	SR.
Alicia	F	Smith-Walke

Luke_C

Hi @Nmassarone

Take a look at this thread, there are a few nuances to consider.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Name-Parsing-Question/td-p/423571

@Luke_C thank you for the post this was helpful i was able to take that and tweak it to get the results

@binu_acs this is exactly what i needed thank you for this sorted everything perfectly.

appreciate the responses and the help on it thank you so much.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703