Alteryx Designer Desktop Discussions

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

Regex characters in a string

catmar
7 - Meteor

I got a string that I need to Regex. The string looks like the example below but has many more character to follow.

 

PAGE1SCHEDULETOINVOICEFORVENDORCODEABCVENDORNUMBER..............................................

 

I want to parse ABC only. At times it could be three digits and other times two digits. When doing: VENDORCODE(.*)VENDOR I get everything after VENDORCODE while I only want ABC.

 

Similarly, I need to parse the number 1 after Page and before Schedule. Page(.*)Schedule gives me an output of everything after Page. 

 

Any ideas on how the Regex should be formatted? 

4 REPLIES 4
binuacs
20 - Arcturus

@catmar One way of doing this

image.png

catmar
7 - Meteor

Thank you! Parsing the page works great. The vendor code is at times three digits and at times two digits, with the current solution it always pulls three digits. Is there a work around?

binuacs
20 - Arcturus

@catmar try now

image.png

catmar
7 - Meteor

Thank you! 

Labels