I am working on one automation project .With the help of a few youtube videos (Anders Jensen) and megapost shared on forum by Steven_McKeering, I have made two processes. But not able to get the required result.
I would be glad if you could help me on this.
Requirements for the project are as follows.
There are multiple REGEX rules added in the Excel sheet so I need to check all regex rules mentioned in excel file to extract data points available in PDF file.
There are multiple PDF files available in Folder at a specific path, so the process must check all regex rules in each and every PDF file available in folder and extract data.
For your reference I am attaching Excel file with regex Rules, 07 PDF Files and RPA file.
When I execute Regex_02,I am getting below outcome – it works on only one PDF in read pdf.
In this case outcome should be reflecting only one time in each row. However it is duplicated in the first and second row.
When I execute Regex_03,I am getting below outcome - it includes all PDF available in folder.
Regex rule for LSE_.xlsx (17.1 KB) 04.pdf (118.2 KB) 05.pdf (132.2 KB) 06.pdf (537.1 KB) 07.pdf (43.2 KB) 01.pdf (271.9 KB) 02.pdf (51.6 KB) 03.pdf (360.9 KB)
Main.xaml (12.0 KB) Regex_03.xaml (13.5 KB)