ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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
binu_acs
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