Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
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. 

 

 

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