Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Parse a specific text from a string

Highlighted
7 - Meteor

Hi folks,

 

I'm trying to parse a particular part of a wider string at the minute and running into a blocker (Mostly I think because I can't wrap my head around RegEx).

 

I have a file format that is setup as;

 

Z:\Projects\Test Zone UK18-0001\additionalfiles.txt

Z:\Projects\US18-0041 Gibberish\additionalfiles.txt

Z:\Projects\Sub-Cat\UK18-0001\pics.jpeg

 

and the such.

 

What I want to pick up on is the UK18-0001/US18-0041 section of this. I've tried Text to columns but the main problem is that the folks who manage this file structure do not keep to the same format everytime. But they do include the code for the project, so I want to extract that so I can just have a table of them.

 

How on Earth would I do this? 

 

Any suggestions would be grand.

 

Cheers

 

Bs

Highlighted
12 - Quasar

Hi, if the text you would like to extract is always in the same format, I would suggest using Regex tool:

 

Capture1.PNG

 

Labels