topic Re: Read Tabular Data Row wise from PDF in Workato Pros Discussion Board

Read Tabular Data Row wise from PDF

himanshu — Mon, 16 May 2022 17:41:50 GMT

Hello All,

I am trying to build a solution that can read values from a PDF & post it to a database engine.

DocParser seemed to be promising but was not able to read the row wise data from it.

Also DocParser is a paid service so I tried JavaScript/Python block based solutions but was not able to import library files .

Attached is the screenshot of sample PDF.

Any solutions/suggestions please?

Thank you.

Re: Read Tabular Data Row wise from PDF

rayudu_addagarl — Mon, 16 May 2022 20:07:29 GMT

There are limitations of Python libraries that can be added

Might have to use Amazon text tact or adobe cloud services for this use case or hyperscienece etc , all those have cost tonier

Rayudu Addagarla

Sr Manager ,Business Consulting

Toronto, Canada

Re: Read Tabular Data Row wise from PDF

patrick-steil — Mon, 16 May 2022 20:53:43 GMT

Himanshu, are you able to copy / paste text from the tabular data section? If you cannot, the text might not actually be text that can be exported directly and may need some type of OCR solution.

Re: Read Tabular Data Row wise from PDF

himanshu — Tue, 17 May 2022 18:26:54 GMT

Hello Patrick,

Good suggestion.

Yes this is a text which is selectable.

Re: Read Tabular Data Row wise from PDF

james-ng — Sat, 21 May 2022 17:07:43 GMT

for OCR solution, you could try the app "Google Lens"

Re: Read Tabular Data Row wise from PDF

meghan-legaspi — Tue, 31 May 2022 22:18:02 GMT

Hey Himanshu Sharma, were you able to find a solution here?