Extract each emails in single cell and make it unique and concat with comma

Question

Hi,

I have unstructured string data including tons of emails in a single cell. (around 5k row)

Inputs:

for eg, " Daniel. Beaudoin@x.Com'""Andrew.Sharp@x.ComBarbara.Zukor@x.ComBarbara.Zukor@x.Com / "

for eg, " Adam.Altberg@x.Com,Joe.Quinn@x.Com,Joe.Quinn@x.Com; Geoffrey.Cardy@x.Com,Joe.Quinn@x.com    "

Note: There is no delimiter here. Separated either by , or ; or  / or / / or ( )

Note: Almost every kind of domain is there(.uk,.org,.ca,.com etc.)

Outputs:

for eg, "daniel.beaudoin@x.com,  andrew.sharp@x.com,  barbara.zukor@x.com"

for eg, "adam.altberg@x.com, joe.quinn@x.com, geoffrey.cardy@x.com   "

Summary:

need to clean each single cell and have it ready each unique emails in one cell seperated by comma(,)

Regards,

AncientPandaman · Answer

then no choice to build a table for the ending (.com, .co.uk, .ca and etc.)

to more accurate, delimiter a used separate email as well.

however, it will split if the name have space in between.

this workflow required run and verified new email address ending and repeat until all data is analyzed.

email extractor.yxmd

mertmetinn · Answer

I am pulling data as csv from db, I am using that csv as an input for Alteryx workflow.

mertmetinn · Answer

Another example:

""derekaguthrie@gmail.com; sarah@sarahmcquaid.com /// Julian Stair - has applied for POA over Derek -->Julian@Julianstair.com // Craig Ward lawyer: craig.ward@craybecklaw.co.uk; // Sophie OConnell: soconnell@wolferstans.com""