Hi All,
My source data has rows like -
A sample input I've taken.
The output should be in 2 columns and it should be dynamic -
Please help using Regex only.
Solved! Go to Solution.
A little typing mistake on the above, output columns should be like -
I can able to build the build column this way
Based on your output, I think these are the formulas you need. You've specifically requested RegEx, but you can also do this without.
Column 1: if REGEX_Match([Source], "[^\|]+") then [Source] else Null() endif
Column 2: if REGEX_Match([Source], "[^\|]+\|MAPP") then [Source] else Null() endif
Thank you very much, it worked perfectly the way I wanted.
I tried to use a Filter tool -
Column 1: !REGEX_MATCH("[Source]", "\w+\|.+")
Column 2: REGEX_MATCH("[Source]", "\w+\MAPP")
Cool.