How to trim the string for separating it in different columns


I would like to trim the string as below using regex in UiPath

Input : Horton, Jeremy
Output : Last_name First_name Email like Horton Jeremy

I want the output to be written in different columns , FYI I have n number of columns present in my input excel sheet.

Kindly help, Thanks in advance : :slight_smile:


Why dont you remove the comma

replace (β€œHorton, Jeremy”, β€œ,”, β€œβ€)

Hi @selvarani1390,

@skini76 is right.

Just replace the comma (,) with "" and then use a split string

StringArray = StringVariable.Split("Environment.NewLine"c)

this will give you LastName at Index 0, FirstName at 1 and Email at 2