I am trying to use the Regex tool to parse data between two semicolons.
My data looks like this
;ba1234;dr-y12; |
;ca5678;kr4356k2465; |
I am trying to get it to look like this
ba1234 | dr-y12 |
ca5678 | kr4356k2465 |
How do I configure the Regex tool to do so?
Solved! Go to Solution.
You can use the expression: ;([^;]*);([^;]*); when parsing.
Each of the two groups are "any non semi-colon" within the string.
See Attached.
Best,
Michael
Typically I would, it is much easier to get it to work.
In this case I assumed that there were other reasons that the regex tool was already being used.