Invoice processing 1

Help
1

How to extract specific field from
EXIDE

Exide

VidyaNagar Invoice No : 100

Hubli, Karnataka, 580031 Date : 1/10/2020

0836-2372584 Customer ID : ABC12345

vasanth@exide.in

Gangadhar Wali

Invibes

Basweshwar Nagar

Bangalore,Karnataka,560079

Phone:080-2375489

Quantity Description Unit Price Line Total

5 Battery 5V 200.00 1000.00

15 Battery 10V 250.00 3750.00

10 Battery 25V 200.00 2000.00

4 Battery 15V 220.00 880.00

Subtotal $ 7,630.00

Sales Tax @ 9.50% $ 724.85

TOTAL $ 8,354.85

Make all checks payable to Exide.

THANK YOU FOR YOUR BUSINESS!

2

what are you trying to extract from above String??

3

company name, invoice no, date,Quantity, Description ,Unit ,Price Line, Total

4

@Arun.k Is that Extracted from PDF ?

5

yes but the requiredment is don’t open pdf

6

can you provide us the sample text file after reading the pdf so that we can help you ?

7

yes sure

8

@Arun.k Will the Format of all similar PDF’s remain the Same?

9

abc.txt (600 Bytes)

10

and give us sample output company name, invoice no, date,Quantity, Description ,Unit ,Price Line, Total for these

11

yes sir

12

please help me

13

PDF-Extract-PDF-Data.zip (805.7 KB)

Try with this Hope it will work… i tried this with different invoice. you can use similar logic to overcome with your road block

14

what is the company name in this example?

15

Exide

16

is this only pdf or you other pdf’s with different company names?

17

yes, other pdf with different company name