Parse between two semicolons

[krichardson29]

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?

[MichaelLaRose · Accepted solution]

Hi @krichardson29 

You can use the expression: ;([^;]*);([^;]*); when parsing.

Each of the two groups are "any non semi-colon" within the string.

See Attached.

Best,

Michael

[OmarP]

Don't you prefer the Text-to-column tool for this?

[MichaelLaRose]

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.