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?
Solved! Go to Solution.
@catmar One way of doing this
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?
@catmar try now
Thank you!