Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Parse

Simon1187
9 - Comet

Hi everyone!

 

 

 

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

 

Thanks, 

Simon

 

 

 

 

3 REPLIES 3
clmc9601
13 - Pulsar
13 - Pulsar

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. 

 

Screen Shot 2021-12-06 at 10.58.23 PM.png

Jonathan-Sherman
15 - Aurora
15 - Aurora

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:

 

 

 

\((.*)\)$

 

 

 

JonathanSherman_0-1638869015265.png

 

Kind regards,

Jonathan

 

Jonathan-Sherman
15 - Aurora
15 - Aurora

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)

 

 

JonathanSherman_0-1638869361098.png

 

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

 

Kind regards,

Jonathan

Labels