removing unnecessary characters from email id

Question

Hi , I have this requirement of removal of characters from email id . We upload many email id before sending email to stakeholders . but the email id's contain characters as shown below : ;1234;;3445;;24665 and so on . My requirement is just pick up email id and any two email id must be separated with ; Is it possible. Thanks.

HomesickSurfer · Answer

Hi @praneshsapmm

This should work for you, assuming that your values are in 1 string record.

email id.yxmd

DawnDuong · Answer

hi @praneshsapmm

You can use the Regex tool to solve that by first get the list of all the emails in different rows (see below). and then concatenate the rows with the semicolon as the separator (not shown here)

Helpful PEARL syntax link

https://www.boost.org/doc/libs/1_68_0/libs/regex/doc/html/boost_regex/syntax/perl_syntax.html

Tokenize Regex.yxmd

KarolinaRoza · Answer

Hi, Please find my proposed solution: - text to rows - filter that contains "", here: you can apply instead of for example "@" if it is email address - summarize: concatenate with ";" Let me know if it works, Karolina email.yxmd