Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
@Data_Alter, one option is to use Regex to pattern match and parse the text you want.
this regex for this works on the data you gave as an example:
(PQ.*?-[^-]*|WPL-\D+-\d+|WPL \d+ \d+|WPL\d+-\d+)
The pipe | separates the different pattens in the example. For instance, the first pattern I found was
PQ.*?-[^-]*
This matches with PQ then any characters before a dash then a dash then any character which is not a dash.
If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...
Any questions or issues please ask
Ira Watt
Technical Consultant
Watt@Bulien.com
