Parse

[Simon1187]

Hi everyone!

I am trying to get emails that are in parentheses. Could you please help me with this? 

Thanks, 

Simon

[clmc9601 · Accepted solution]

Hi @Simon1187,

Would this work? I used regex to capture every character between the sets of parentheses.

If it helps, please consider marking it as a solution so others may find it. 

[Jonathan-Sherman · Accepted solution]

Hi @Simon1187,

I would use regex in the same way as @clmc9601 but would use a slightly different expression, simply extracting the data between the two parenthesis in parse mode:

\((.*)\)$

Kind regards,

Jonathan

[Jonathan-Sherman · Accepted solution]

It's also possible to extract the emails using Substring functions also if you want to avoid the Regex method entirely:

Substring([Associated Contacts],FindString([Associated Contacts], '(')+1,FindString([Associated Contacts], ')')-FindString([Associated Contacts], '(')-1)

I love the fact in Alteryx there's so many ways to solve the same problem!

Kind regards,

Jonathan