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
8 - Asteroid

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
21 - Polaris

@catmar One way of doing this

image.png

catmar
8 - Asteroid

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
21 - Polaris

@catmar try now

image.png

catmar
8 - Asteroid

Thank you! 

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels