Need help in Regex expression

[EN6924]

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.

[EN6924]

A little typing mistake on the above, output columns should be like -

[flying008]

Hi, @EN6924 

What is your logic with the output ?

[EN6924]

I can able to build the build column this way

[Christina_H · Accepted solution]

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

[EN6924]

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")

[EN6924]

Cool.