We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

RegEx Get All Characters after Different Strings

jkv0019
8 - Asteroid

I have two different strings and underscores and am trying to get all characters after these different strings and underscores. I am using OTHER_WORD and WORD to denote two different strings, the word is not in common

Strings:
OTHER_WORD_and the rest of the string
WORD_and the rest of the string

Desired output:
and the rest of the string

I can get the results with 2 different columns, but I'd like to keep the result in 1 column only and avoid replacing any nulls with a non-null from the other column.
My attempt: OTHER_WORD_(.*)|WORD_(.*)

2 REPLIES 2
binuacs
21 - Polaris

@jkv0019 If you are looking for all the string after the '_' then you can use the below regex

image.png

kamal03
9 - Comet

Hi @jkv0019 

 

An alternate approach would be to use a formula tool.

 

Using formula tool.png

Labels
Top Solution Authors