Only including data after a certain character appears in the Data

[NRD]

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?

[T_Willins · Accepted solution]

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

[NRD]

@T_Willins Thank you very much, this works!