2 email addresses in the same cell

hello,

I'm cleaning a customer file in which the email address is stored.

For many records, there are 2 email addresses separated with a comma, a semi-column, a slash (/) or a dash.

I wish to keep only the first email address

could you please help me?

thanks

myraim

Transformation

Preparation

Accepted answers

thanks Vishwa! it works fine!

All comments

Split the email address with Regex tool and use the select tool to keep first email alone.

I have attached my solution. Hope it helps.

If you have any queries let me know.

Hi Haroon_sa

thanks for this solution.

I understand that it creates 2 new columns.

and I need a new step to select one of them.

Is there any way that removes the second email from the original column?

many thanks

Myraim

I guess this much simpler regex will solve your issue. It will just keep the first email adress without any punctuation mark at the end. in square bracket i have given comma, semi-colon,dash and a slash. You can also add any wild characters in that square bracket.

Regards,

Vishwa

thanks Vishwa! it works fine!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703