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
Asteroide

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 RESPUESTAS 2
binuacs
Arturo

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

image.png

kamal03
Cometa

Hi @jkv0019 

 

An alternate approach would be to use a formula tool.

 

Using formula tool.png

Etiquetas