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.

Need help parsing string using RegEx

Hoss2434
7 - Meteor

Hello all, I am new to RegEx and Alteryx as a whole and could really use some assistance.

I have the following rows:

 

ROCK:NO, BAT_APP:LEVEL STATUS One, TEST:Y, MONTH:AUG

BAT_APP:LEVEL STATUS Two, TEST:Y, MONTH:SEP

ROCK:NO, BAT_APP:LEVEL STATUS Three, TEST:Y, MONTH:OCT

 

 

I am just trying to parse the colored text, which is everything that begins with the word BAT_APP to the text before the first comma. 

I have tried using lookaheads but can't seem to get the function to work, or include the text BAT_APP.

 

Any help would be greatly appreciated.

Thanks!

3 REPLIES 3
cmcclellan
14 - Magnetar

cmcclellan_0-1632283188062.png

 

cmcclellan_1-1632283209201.png

 

You can make this simpler, but I've done this :

 

Substring([field],FindString([field], "BAT_APP"))

and then this:

left([new], FindString([new], ","))

 

 

Qiu
21 - Polaris
21 - Polaris

@Hoss2434 
I gave a try with RegEx.

Capture2A.PNG

atcodedog05
22 - Nova
22 - Nova

Hi @Hoss2434 

 

My take on this. Using regex tool parse mode.

 

Workflow:

atcodedog05_0-1632292673052.png

 

Hope this helps : )

 

Labels
Top Solution Authors