Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Parse between two semicolons

krichardson29
5 - Atom

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

ba1234dr-y12
ca5678kr4356k2465

 

How do I configure the Regex tool to do so?

3 REPLIES 3
MichaelLaRose
10 - Fireball

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
Alteryx Alumni (Retired)

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

MichaelLaRose
10 - Fireball

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.

Labels