How to split Excel row values based on separator

[rsr.chandu]

Hi,

PFA

I am trying to extract email address row values for each row I’M having different separators like (,)(.) etc. How to split these values based on different separators

Thanks in advance

[pradyumn.agrawal1 (Pradyumn Agrawal)]

Hi,
You can use generate data table activity, there you have the column separator

[Praveen_Mudhiraj]

Can you elaborate more on this if we split the emails what after splitting we need to add separate column or do the process

@rsr.chandu

[rsr.chandu]

After splitting these emails we need to add it into separate column

[Praveen_Mudhiraj]

Hi

try this way it will add to the separate column then

Note : - instead of log message you can use the Add data row activity to add the column

for each condition

System.Text.RegularExpressions.Regex.Split(CurrentRow(0).ToString,"(?:[;,])")

input : -

output : -

@rsr.chandu

[Praveen_Mudhiraj]

Let me know its working or not for you

@rsr.chandu