Hi, Thank you in advance for your help.
In the example below, the data may have multiple parenthesis and I would like to break them out into 2 columns where the last column is always the last parenthesis.
Title | RegexOut1 | RegexOut2 |
Title 1 (A) | Title 1 | (A) |
Title 2 (B) (C) | Title 2 (B) | (C) |
Title 3 (D) (E) (F) | Title 3 (D) (E) | (F) |
Solved! Go to Solution.
Hi @AngelosPachis ,
Thank you but your solution only works partially in my real data. I ended up looking for the pattern and insert a | delimiter. Then I use Text to Column to separate out the string.