Column Correction for Name and Employee ID

[Puneet13]

Hi Below is my question how to convert Inputs into correct output using Alteryx, can somebody provide me the solution.

Input	Output Needed
AnamikaVishnoi (11111111)	Vishnoi,Anamika(11111111)
Awasthi,Aman (2222222)	Awasthi,Aman (2222222)
BishalBhandari (33333333)	Bhandari,Bishal (3333333)
ChandanUpadhayay (44444440)	Upadhayay,Chandan (4444444)
DeepakNegi (555555555)	Negi,Deepak (5555555)
Dhami,Harish (9999999)	Dhami,Harish (9999999)
DharmeshKumar (99889898)	Kumar,Dharmesh (9988989)

[FinnCharlton]

Hi @Puneet13 , here's how I would approach this:

The RegEx can be updated to account for different types of names, ie those with punctuation. Hope this helps!

[MilindG]

@Puneet13  One way to do this

[Puneet13]

Thanks the quick response below is the also one more item available in the output could you please provide solution along with that it would be great help.

Input - AmreshKumarSingh (001175372) 
Output - Singh,AmreshKumar (001175372)

[cjaneczko]

Try this. Adjust the column names as needed. Not sure which names are first names, vs last names. 

[cjaneczko]

Actually I see you dont want to split them out separately. I'll post the updated one in just a second.

[cjaneczko]

Try this one.

[Puneet13]

Wont work for me it not showing as asked, sorry for the asking questions

Input	Output Needed
AnamikaVishnoi (11111111)	Vishnoi,Anamika(11111111)
Awasthi,Aman (2222222)	Awasthi,Aman (2222222)
BishalBhandari (33333333)	Bhandari,Bishal (3333333)
ChandanUpadhayay (44444440)	Upadhayay,Chandan (4444444)
DeepakNegi (555555555)	Negi,Deepak (5555555)
Dhami,Harish (9999999)	Dhami,Harish (9999999)
DharmeshKumar (99889898)	Kumar,Dharmesh (9988989)
MohdMujahidKhanSaddam (001448954)	Saddam,MohdMujahidKhan (001448954)

[FinnCharlton · Accepted solution]

@Puneet13 , try this: