How to extract data from unstructured pdf table

Help
, , ,
1

Hello all,
Currently i am doing Data extraction from a pdf. But i have been facing problem to extract data from unstructured table. My task is to extract data from pdf table and save those data into excel file. Please check the screenshot of pdf unstructured table

unstructure_table
unstructure_table876×462 14.5 KB

i have to extract that table data first.

Please note that data scraping is not working in this case . If anyone done this before please help me with your tricks .

Thanks in advance.

2

Hi
Did we try converting the pdf to excel and then try fetching the data

Cheers @roysupriya21

3

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

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