Alteryx Designer Desktop Discussions

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

RegEx Parsing problem

BS_THE_ANALYST
14 - Magnetar

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. 

 

 

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
14 - Magnetar

Thanks for sharing.

grazitti_sapna
17 - Castor

Here is one more way to achieve this:

 

grazitti_sapna_0-1674456826159.png

 

Sapna Gupta
Labels