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

[Nmassarone]

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

[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

[binuacs · Accepted solution]

@Nmassarone 

[Nmassarone]

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

@binuacs 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.