How to split Excel row values based on separator



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

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

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


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


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


input : -


output : -



Let me know its working or not for you


1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.