removing unnecessary characters from email id

[praneshsapmm]

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 : 

<email id >;1234;<email id>;3445;<email id>;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.

[KarolinaRoza]

Hi,

Please find my proposed solution:

- text to rows

- filter that contains "<email id>", here: you can apply instead of <email id> for example "@" if it is email address

- summarize: concatenate with ";"

Let me know if it works,

Karolina

[DawnDuong]

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

[HomesickSurfer]

Hi @praneshsapmm 

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