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
20 - Arcturus

@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