I have run into a bit of a problem that i can’t figure out, and I’m hopping that someone can direct me toward a solution, as you’ve done before.
So, the idea of the process is as follows: i have a high number of PDF Files, out of which i have to extract some information: contract date, amount and contract number and also add the name to the file, for easy identification. This part i managed to do, using regex and “matches” to look up the information and building a data table which i write into an excel file at the end.
My problem is as follows - how can i make the automation skip any PDF file that is outside of the template that i need? i tried using an if function combined with an “is match” - didn’t work, tried using “try catch” - that didn’t work either. I’m not saying that those wouldn’t be the solutions, but that i could have used them wrong
Any suggestion would be of help.