Parse between two semicolons

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?

Regex

Parse

Accepted answers

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

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

See Attached.

Best,

Michael

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

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

See Attached.

Best,

Michael

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

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.