topic RE: Extract of text from PDF in Product Forum

Extract of text from PDF

pokojskamartyna — Fri, 29 Apr 2022 14:07:00 GMT

Hello,

Do you have any good recommendation for the extract of text from a PDF file?
I have been looking at iText and Adobe API, however both are not available for free (for iText a commercial license is required and Adobe has only a free trial version for 6 months).
Looking forward to your replies 🙂

Martyna

------------------------------
Martyna Pokojska
------------------------------

RE: Extract of text from PDF

ManpreetKaur1 — Fri, 29 Apr 2022 19:08:00 GMT

Hi @Martyna Pokojska,

Did you try fetching the data by creating a small process which will just launch PDF, performs Ctrl+A to select the data, Ctrl+C to copy the data and then pasting the data in your desired location e.g. notepad?
Or you are specifically looking for external tools only to read the data?

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------

RE: Extract of text from PDF

pokojskamartyna — Wed, 04 May 2022 05:31:00 GMT

Hi @Manpreet Kaur,

I would like to avoid opening the file, therefore I'm searching for other options.
Additional problem with this PDF is, that part of it is interactive, so even when I'm opening it and save as txt file -> some values are not transferred to txt

------------------------------
Martyna Pokojska
------------------------------

RE: Extract of text from PDF

devneetmohanty07 — Wed, 04 May 2022 10:14:00 GMT

Hi Martyna,

You can use the following DX Exchange asset which will convert your PDF file to Excel using in-built Office operations hence no licensing issue should happen as long as you have a valid Microsoft Office software suite with you: Function for DX InDev PDF to Excel Converter

Once you have the data written on the excel file, you can use the 'Utility - MS Excel VBO' for extracting the content to a text file if required.

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: Extract of text from PDF

Jatin__Kalra — Wed, 04 May 2022 14:24:00 GMT

Hi @Martyna Pokojska,

We can achieve this functionality using python code.
Write python code and call it from Process Studio. It will convert all data into Text file. Then we can read that text file.
Python code is easily available on Internet.

------------------------------
Jatin Kalra
Manager
Genpact
Noida UP
------------------------------