Regex Parsing

[ChrisTan]

Hi, i am trying to parse out the first name and LAST name of this list of data. As i'm new into regex, the best i can get to is the below. Any help to complete the workflow is greatly appreciated. 

Attached the workflow that i have

Current Data:

	Name
1	Abc XYZ
2	XYZ Abc
3	Abc XYZ Def
4	Abc Def XYZ

Cleansed Data:

	Name	Last Name	First Name
1	Abc XYZ	XYZ	Abc
2	XYZ Abc	XYZ	Abc
3	Abc XYZ Def	XYZ	Abc Def
4	Abc Def XYZ	XYZ	Abc Def

[AbhilashR]

Hi @ChrisTan, not sure if this is what you were looking for but I took your regex output and used a Replace function to fetch the Last Name.

Replace([Name],' '+[RegExOut1],'')

[ChrisTan]

Hi, the results is only good for some of the records. Somehow it doesnt work for others:

e.g: Chris TAN will return the same results for First Name

[PhilipMannering · Accepted solution]

This might do the job..

[ChrisTan]

Works fantastic!!! Thank you for your help!!