Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

RegEx Parsing problem

BS_THE_ANALYST
15 - Aurora
15 - Aurora

I was just playing around with some data earlier and stumbled on a nice RegEx problem: 

 

BS_THE_ANALYST_0-1674260074796.png

 

Two approaches so far for it:

1.  Parsing + some data manipulation to get it into desired format

BS_THE_ANALYST_1-1674260143665.png

 

 

BS_THE_ANALYST_2-1674261033913.png

 

2.  Identifying the groups singularly via replace, & then some text manipulation. One tool, looks cleaner:

BS_THE_ANALYST_3-1674261145680.png

 

Just thought I'd share. Maybe the insights prove useful for somebody. 

 

 

All the best,
BS

LinkedIN

Bulien
3 REPLIES 3
n8rushton
Alteryx Alumni (Retired)

Hi, I used 3 reg parse tools.

The first being  ([\w\s]*)
The second being .*?(\(\d*\))
The third being .*?(#\d*)\s?

I'm sure there is a way to get them all jammed into one tool, but I'm lazy and it complicates

Raj
16 - Nebula

Thanks for sharing.

grazitti_sapna
17 - Castor

Here is one more way to achieve this:

 

grazitti_sapna_0-1674456826159.png

 

Sapna Gupta
Labels
Top Solution Authors