How to trim the string for separating it in different columns

Help
1

Hi,

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

Input : Horton, Jeremy jeremy.horton@example.com
Output : Last_name First_name Email like Horton Jeremy jeremy.horton@example.com

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:

Regards,
Selva

2

Why dont you remove the comma

replace (“Horton, Jeremy jeremy.horton@example.com”, “,”, “”)

3

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

Thanks,
Prankur