Test line 1 (ABC) (DEF) - need DEF to be extracted
Test line 2 (GHIJ) (KL) (MNO) - need MNO to be extracted
Test line 3 (PQR) - need PQR to be extracted
If multiple groups of parentheses exist then need the last group. I'd like for the data I need to be in the same column if possible. Any help would be appreciated.
Solved! Go to Solution.
(.+)(\<\w+\>) seemed to do the trick to just grab the last one. Would like to see if could grab each group as well if they exist.
hI @alex
If by grabing each group you mean each group in a new column dynamically, here it is one way of doing this:
Can you walk me thru the explanation of what the formula is doing. Thanks!