hey guys, i need a help to exract data from pdf file there are 1-15 pages are there i need a specific transaction data ,
ex; in this pdf 2 page, after word of transaction history like one transaction. i need to exract and store to excel file.
i attached one pdf file please help me to create a flow.without using document understanding.
Thankyou
Please Highlight the data which you want to extract
Please specify what is text you want to extract. We will help you out with regex.
Regards
Try this regex:
\d{1,}\/\d{1,}\s*[\<A-Za-z].*\d*\,?\d*\.\d*
=> Use the above regex expression in Find Matching Patterns activity and input will be the output of Read PDF Text.
Refer the below workflow for better understanding:
Verigy the output with your lineitems:
Output Text.txt (24.6 KB)
Hope it helps!!
Regards
(?<=Transaction history)[\s\S]?((?=Transaction history))|(?<=Transaction history)[\s\S]?(?=Total amount)
Please Try This Hope this will help you
Use Find Matching Pattern Activity
one line item is missing in description other wise your given output is okk,
i will share the example pdf ,exract and send the xaml for me.
thankyou
test.pdf (333.2 KB)
its not working @rlgandu
Please Mention The data from where to where you want to extract
Highlight it in pdf it will be easy
Do not copy and paste the regex from the above try to type the expression by seeing the Screenshot
I will add sample pdf,
in this pdf after the Transaction history have one transaction table is there
that one aslo different tables are there in the pdf. all the table i want extract and store it to excel file
thankyou @rlgandu
test.pdf (333.2 KB)
=> Use Read PDF Text to read the PDF and store the output in a variable say str_Text.
=> Use Write Text File activity to write the extracted data from PDF to a text document.
=> Use Find Matching Patterns activity and give the below regex:
(?<=\n\s*)\d{1,}\/\d{1,}\s*[\<A-Za-z].*\d*\,?\d*\.\d*
Properties of Find Matching Patterns:
Happy to help if any questions.
Regards
can you look out this
@mkankatala
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
