Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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