Hi all, I am currently working with an invoice template to extract information from the PDF file. I have also been trying to extract this information from a text file which was converted from the PDF. In the example below, there are multiple tables of payments for each invoice given by the client. Each invoice could have just one or many such tables. I would like to extract all the “Amount Payable” amounts from all such tables. Please let me know how I can do this via text file if possible.
Not sure if you git your answer, Looks like you are thinking of extracting all amount payable which are present in text file. There are lot of ways, but I would suggest following.
->use Read Text file activity and store the text in a string variable
->use Generate data table activity to convert the text into data table
->using option to do the formatting of columns etc
->Use Write range to feed the data into excel
Once done you will have a column called amount payable, which you can use.
Sample wf is attched, let me know if this was not your goal. Main.xaml (11.7 KB)