Start Free Trial

Alteryx Designer Desktop Discussions

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

Regex Syntax

jessy_chow
8 - Asteroid

How to write a regex syntax to extract "P:32745" and "P:32553" from the following string of text. 

 

WBS P:32745-T-E

 

jessy_chow_0-1750265770506.png


Also are there any material that can teach me how to write regex syntax? I need an idiots guide to it...

Thanks! 

3 REPLIES 3
binu_acs
21 - Polaris

@jessy_chow one way of doing it

image.png

check the site regex101.com for learning regex

binuacs_0-1750266289876.png

 

jessy_chow
8 - Asteroid

Thank you!! Have the site bookmarked! 

BS_THE_ANALYST
15 - Aurora
15 - Aurora

@jessy_chow based on the videos available through alteryx's interactive lessons: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20... I taught myself regex & I'm pretty darn good at it now! They're also part of the Alteryx Advanced exam's curriculum, so you get a two-for-one 😏. As Binuac's mentioned, regex101 is fantastic, especially for sharing your examples + regular expression as you can save it and send the URL like so:

Screenshot 2025-06-23 204250.png

 

i.e.  https://regex101.com/r/pdrXih/1 

 

 

 

All the best,
BS

LinkedIN

Bulien
Labels
Top Solution Authors