This is the result after read Pdf and write text file.
I had to block out most of the information or else our customer information gets leak
But is there a way to get text under specific keywords using Regex?
I know there’s ways to get words infront or behind, but I don’t see a way to grab words below.
For example, I would like to get the blue column’s data under the B/L #, or the blue column under Container #.
The amount of container # also changes from file to file, sometimes there’s only one, sometimes multiple, sometimes none.
=> Use Read PDF Text or Read PDF with OCR to read the PDF and store the output in a variable say str_text.
=> Use Write Text File activity to write the pdf into the text file.
=> After writing the text file you can use Regex expressions to extract the text.
Share the sample text to extract so that we can help you with regex.
Again, I would need the info after “LOAD PICKUP POOL ADDRESS”, under “B/L #”, under “CONTAINER #”, “LAST FREE DAY”, and "PICKUP # (the amount of items under the last three requirements are random, there might be none, there might be multiple)
