Hi!
I am trying to use a compare a numerical value (id number) in a PDF file name to an excel document with the id numbers (and if a match is found to export the PDF to a different location)
I am having difficulty finding the correct tool/extension for this.
IF there is an option to do this, can a report be generated to tell me if a match was found/not found?
Hi @mia.bryant
Using the regex expression extract the number from the PDF file name and then compare that extracted data with the data in the excel.
Regards
Thanks!
Can regex analyze the PDF file to find the ID; wondering if I can consolidate the extracting file process if regex can search the PDF, find the ID and compare it to the data in excel and if there is a match extract the PDFs.
These PDFs are large (14,000 pages) so I would need regex to search the file for any matches and pull out all the files with a match.
Regex is not a correct solution.
What you need to do is Read Range the Excel file into a data table, then use Filter Data Table (using the numerical value from the PDF), and then see if there are any rows in the result. If there are 0 rows in the filter result, the no matches were found.
Thanks! this is helpful. Will ReadRange only tell me if matches were found? Will this also export the PDFs where matches were found or is that a different process?
Read Range doesn’t tell you anything about matches. Read Range is how you read an Excel file. Have you done the free training at academy.uipath.com? I suggest you should, so you’ll learn how to do these kind of basic things.