11.RPA Challenge - Regex to match Invoice number and Order number on consecutive lines

[charliefik (Clark Coleman)]

Hi All,

Here is my solution. I used a regex pattern that @ClaytonM posted in

Substring after line containing specific text

I’m working on a process that will read PDF text for multiple-page files with an invoice on each page. I was able to figure out how to set the range to read each page separately using a combo of the sample “Counter Example” in UiPath and Vvaidya’s pdfPages xml from this thread: PDF Page Count However, I am still having difficulty with extracting the exact text I need. The text contains many line breaks, and I need to pull back the full text of a given line after a line containing specific text…

(what a legend! I need to try and understand regex a lot more than I do right now)

StringData.Split({“Total Invoice”},System.StringSplitOptions.None)(1).Trim.Split(System.Environment.Newline(0))(0).Trim

To pick the first item after ‘Total Invoice’

StringData.Split({“Total Invoice”},System.StringSplitOptions.None)(1).Trim.Split(System.Environment.Newline(0))(1).Trim

To pick the second item after Total Invoice

Anyway here’s my attempt

Chall11_RegexInvoiceOrder.zip (94.2 KB)

I didn’t need to generate the data table and then convert it back to text (which I had from the Get full text activity) but I think I was considering going through the data table one row at a time to start off with and then I remembered the regex code Clayton had done and also the challenge was about regex right!