Extracting Data from PDF table to csv

Mehdi_El_Aissi · February 25, 2019, 1:26pm

Hey community ! I sould extract a Table from PDF and put it in csv format I tried a lot of activitivies but it doesn’t work (it gaves me an unstructured csv file) can you please help me Thank you guys!

ashoks93 · February 20, 2019, 2:24pm

We used Omnipage Ultimate OCR to convert unstructured PDF to excel files. It works good with unstructured data.

Thanks,
Ashok

Mehdi_El_Aissi · February 20, 2019, 2:42pm

Hey! thank you @ashoks93 but I just wanna know if there is any solution by using uiPath ?

anil5 · February 20, 2019, 2:58pm

Hi,

Is the PDF , native or scanned

If the PDF is native, you can use regular expressions and form a table.

Mehdi_El_Aissi · February 21, 2019, 9:15am

Thank you @anil5 I’m working on it right now I hope I can solve this problem

Divyashreem · February 21, 2019, 12:11pm

Once you are able to read PDF the you can build one datatable and just by split/other string manipulation activities you can add those values into new data table and then write that Data table to csv.

Mehdi_El_Aissi · February 21, 2019, 12:57pm

Thank a lot @Divyashreem but can you please help me with more details ?

Divyashreem · February 21, 2019, 1:29pm

Sure Can i get one sample PDF>?