Extract data from pdf document

Help
, ,
1

I have a pdf document which is an Invoices and I want to extract the information like Invoice No, Issue Date, Total Amt,Tax Amt etc. Can anyone please tell how I can automate this using UiPath.

2

@waseem

  1. use Read PDF Text activity to read data from PDF file and will give you output as String.

  2. And then use String manipulation methods or Regex to get required details from it.

3

Hi
we can either use READ PDF or READ PDF with OCR activity where pass the filepath of pdf as input and get the output with a variable of type string named str_output
–now use a ASSIGN activity where we can either use REGEX or SPLIT or SUBSTRING method to get the term we want
this can done only after reviewing the output of the pdf that we get from pdf activities

Cheers @waseem

4

Hey,Can you help me out on how to use Sub string to extract data eg: subtotal,Tax

1 Like
5

sure
can i have a string obtained from the pdf if possible with those terms in it
so that i can come up with a expression

cheers @waseem

6

BILL_2020_0002.pdf (32.0 KB)

7

from this I need to extract Reference no i.e 2020/0002 and PO no i.e P00013

1 Like
8

Fine
I don’t have my system
Can you do me a favour
Kindly read this pdf with READ PDF or READ PDF with OCR and share that string output so that i can give you the expression based on it
Cheers @waseem

9

is this text fixed Vendor Bill BILL/ 2020/0002

10

here you go
check this sample workflow i’ve used your sample pdfReadPDF.xaml (6.0 KB)

11

No this is Not fixed all invoices have different reference number

12

is that format is fixed?
4digits/4digits ??

13

Yes the format is fixed

14

to get that value you can use this below regex
\d{4}/\d{4}

15

Hi @waseem

Check this

\d{1,4}\d{1,4}

Thanks
Ashwin S

1 Like
16

Thankyou :grinning: :grinning:

17

working??
@waseem

18

I tried using Sub string and it worked.
Thankyou for your help.

1 Like
19

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