Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Only including data after a certain character appears in the Data

Highlighted
8 - Asteroid

Hello,

 

I have a dataset that looks like the below:

 

John Smith (RC12345)

 

I want to create a new column with only RC12345 from the data above.

 

How would I go about doing this?

Highlighted
13 - Pulsar

Hi @NRD,

 

You can use a RegEx parse to do this with the following expression:  .*?\((.*?)\)

.*?   all characters until

\(     open parenthesis - the \ (escape) is required as ( is a Perl special character and the \ is required to indicate find the character and not use it as a special character

(.*?)   return all following characters until

\)    close parenthesis - same escape required as above

 

RegEx Parse.png

 

8 - Asteroid

@T_Willins Thank you very much, this works!

Labels