Full name split

[LuckyRaju]

I need to split the Full Name to First Name and Last Name.  First Name and Last name is separated with either space or any other Special character.  It should work for all the cased.  Can you please provide Regex FORMULA for the below. 

Full Name

TURNER, JANICE

VAN, TAYLOR

BREAULT JASON

LOOBY% CYNTHIA M

Full Name	First Name	Last Name
TURNER, JANICE	TURNER	JANICE
VAN, TAYLOR	VAN	TAYLOR
BREAULT JASON	BREAULT	JASON
LOOBY% CYNTHIA M	LOOBY	CYNTHIA M

[ShankerV]

Hi @LuckyRaju 

This can be achieved with the help of Text to Columns tool.

Many thanks

Shanker V

[ShankerV]

Hi @LuckyRaju 

Please find the use case explained for your scenario.

Many thanks

Shanker V 

[ShankerV]

Hi @LuckyRaju 

Step 1: Input the data

Step 2: Text to columns tool.

Step 3: Data Cleansing tool used to remove the white spaces

Many thanks 

Shanker V

[Prometheus]

I think you can split the Full Name using a regular expression or you can do what I did and that's replace the comma with a space, remove extra spaces, then use the Text To Columns tool and parse on the space, which is "\s". 

[flying008]

Hi, @LuckyRaju 

RegEx tool parse method for you:

^([A-Z]+?)[^A-Z]+(.+?)\s?$

[caltang]

You can try:

(.+?),?\s(.+)

Add a Data Cleanse tool thereafter to remove whitespace and it'll be all good.