I can’t Extract this pdf file. i used get text activity but it extracted whole pdf, can’t able to extract particular text. so, please help me out
Give me the list of fields you want out of this document
Beneficiary Account, Amount, Payment Date, Remarks
@badal_patel - Convert it to text file using “Read PDF Text” activity with Preserve Format set to True and then use Regex to extract the details…
Note: Attached pdf, is not an invoice…
try to use Document understand
can you please send me a flow ?
i want to extract data from pdf and save into excel file, so i need each extract data item into variable
The fields are saved in variables in the process I sent to you
Just add each variable to a data table and write or append range to get your data into excel
Typpa_Payment_Recpt_101220.pdf (58.6 KB)
i want this pdf extract also. both Megahertz_Payment_Recpt_ST250_SRVR_01-03-2021.pdf (60.5 KB)
@badal_patel - Did you tested my code?? if yes, just pass the second pdf and let me know the result.
yes second code working fineTyppa_Payment_Recpt_101220.pdf (58.6 KB)
@badal_patel - My code is failing on the second pdf…because your first pdf has the word “Network” in the same line a Remarks, which is missing on the 2nd one.
try this and aslo slove INR problem
@badal_patel - what is INR problem?
i dont want INR in amount in Excel file
Fixed…Here you go… Regex_BP.zip (221.3 KB)