Can anyone suggest a best way of looping through the multiple PDF’s (reading data) from local drive and deleting the PDF after the process id done. I tried "delete’ activity to deleted PDF but, name of the file and path of it should be dynamically generated while deleting also. Please suggest me as good possible way to approach.
I have been able to read strings of multiple PDFs using a For each loop.
Now, I wish to capture the relevant sub string from each PDF into an excel file. How can I do it?
I can get a relevant string from each PDF using REGEX
“Vendor:” +System.Text.RegularExpressions.Regex.Match(output,“.+(?=LTD).*”).Value
Question:
How do I capture this information into excel - different row for each PDF?
Please, could you help?
Just create a datatable with suitable columns as per your needs. then inside your for each just use add data row and add the data into that datatable and after your loop execution done just dump that datatable into an excel.