Extracting Table from PDF

[deepan.b]

Hi everyone, I have a pdf file (Bank Statement) and I want to fetch transaction table from it to excel using Tesseract OCR. I have tried with data scraping and screen cannot able to be captured. since tesseract ocr is passing completely as string, is is possible to extract to data table? Below is the output from tesseract OCR,

Your Transaction Details
Date Details Withdrawals Deposits Balance
Apr 8 Opening Balance 5,234.09
Apr 8 Insurance 272.45 5,506.54
Apr 10 ATM 200.00 5,306.54
Apr 12 Internet Transfer 250.00 5,556.54
Apr 12 Payroll 2100.00 7,656.54
Apr 13 Bill payment 135.07 7,521.47
Apr 14 Direct debit 200.00 7,321.47
Apr 14 Deposit 250.00 7.567.87
Apr 15 Bill payment 525.72 7,042.15
Apr 17 Bill payment 327.63 6,714.52
Apr 17 Bill payment 729.96 5,984.56
Apr 18 Bill payment 223.69 5,710.87
Closing Balance $5,710.87

[Akshay07 (Akshay Suryawanshi)]

Hello @deepan.b,

Welcome to the community,

There is a activity to extract tables from pdf to excel. Have a look at it.

Feat Systems - PDF to Excel - RPA Component | UiPath Marketplace

[NIVED_NAMBIAR (NIVED N)]

Hi @deepan.b welcome to forum

For extraction of tables from PDF

You can use document understanding feature of UiPath

Check this video for understanding of extraction of tables from PDF using document understanding feature by @Parth_Doshi

Document Understanding Extracting Table From PDF

Hope it helps you

Regards

Nived N

Happy Automation

[Cristian_Negulescu]

Hello Deepan,
In this video, I extract tables from PDF and write data in Excel:

UiPath Video Tutorial for PDF (extract Tables from PDF)

0:25 Install PDF Activities
1:10 READ PDF text, Get PDF page count, Extract PDF
5:40 Read PDF with OCR
6:55 Join PDF and Manage PDF passwords
9:30 Extract Images From PDF and Export PDF as Image
12:00 Extract table from PDF use-cases 1 replace some spaces with | (one column has multiple words)
24:00 Run the robot to see the result
25:40 Extract Table from other PDF use-cases 2 delimiter is 2*spaces " " easy split
31:50 Extract Table from complex PDF use-cases 3 unstructured data the logic will be based on IsUpper and IsLower
40:25 Extract the price value from PDF

Thanks,
Cristian Negulescu

[prasath17 (Guru)]

@deepan.b - Please take a look at this post…Exactly the same data has been posted and the solution has been offered…

Need regex to extract the data

Hi Team, I need to extract the the Date, Details, Withdrawals, Deposit and Balance from a PDF. I read the PDF text and I need regex to extract the information for each field. Below is the text please help me with the regex. Apr 8 Opening Balance 5,234.09 Apr 8 Insurance 272.45 5,506.54 Apr 10 ATM 200.00 5,306.54 Apr 12 Internet Transfer 250.00 5,556.54 Apr 12 Payroll 2100.00 7,656.54 Apr 13 Bill payment 135.07 7,521.47 Apr 14 Direct debit 200.00 7,321.47 Apr 14 Deposit 250.00 7.567.87 …