How to read specific pdf text

Help Studio
, ,
1

Hello,

Please find the attached image-1

An invoice for a booth at the Sw Car Wash Assn Annual Convention, with a total amount of $486.54, has a remaining balance due of $291.94. (Captioned by AI)
An invoice for a booth at the Sw Car Wash Assn Annual Convention, with a total amount of $486.54, has a remaining balance due of $291.94. (Captioned by AI)1065×272 38.3 KB

I want to extract invoice balance Due & Invoice Total
From Image -2

The image displays an invoice summary for a floor plan with a total amount due of $291.94 after adjustments. (Captioned by AI)
The image displays an invoice summary for a floor plan with a total amount due of $291.94 after adjustments. (Captioned by AI)1055×355 28 KB

I want to extract Invoice Total USD & Payments Due
I tried various methods although i was stuck in middle

Thanks in advance

Forum Engagement Daily Reports
2

Hi @rsr.chandu,

Please refer below post on same.

As it’s a structured pdf, you can read pdf text, save it in a variable and use refer to extract the desired text. This also has link for how to create regex expressions.

Regards
Sonali

3

Hi @rsr.chandu

In order to read the text you can make use of Read pdf text (With OCR if the pdf is scanned) and store it a variable say textOutput
Check this workflow

This image shows an automated process flow where a PDF file named "invoice_output.pdf" is read using OCR, and the invoice due and total values are assigned using regular expressions. (Captioned by AI)
This image shows an automated process flow where a PDF file named "invoice_output.pdf" is read using OCR, and the invoice due and total values are assigned using regular expressions. (Captioned by AI)703×512 15 KB

InvoiceDue = System.Text.RegularExpressions.Regex.Match(textOutput, "(?<=Invoice Balance Due\|*\s*).[\d.]+").Value
InvoiceTotal = System.Text.RegularExpressions.Regex.Match(textOutput, "(?<=Invoice Total\s*).[\d.]+").Value

Output:

An invoice for $486.54 with a balance due of $291.94 and details of a convention center event in Fort Worth, TX. (Captioned by AI)
An invoice for $486.54 with a balance due of $291.94 and details of a convention center event in Fort Worth, TX. (Captioned by AI)476×343 6.52 KB

Hope you can do it for the second image

If you are working multiple pdf structures you should go for Document understanding
Hope this helps !

2 Likes
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.