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_(.*)
@jkv0019 If you are looking for all the string after the '_' then you can use the below regex