knowledgebase:extracting_data_from_pdf_tables

Extracting Text from PDF table

Download and install python from https://www.python.org/downloads

open command prompt and run:

pip install pdfminer

This will install PDFMiner python library for working with PDF files

PDFMiner is a tool for extracting information from PDF documents. Unlike other PDF-related tools, it focuses entirely on getting and analyzing text data. PDFMiner allows obtaining the exact location of texts in a page, as well as other information such as fonts or lines. It includes a PDF converter that can transform PDF files into other text formats (such as HTML). It has an extensible PDF parser that can be used for other purposes instead of text analysis.

https://pypi.python.org/pypi/pdfminer/

External Link

With help of stackoverflow we created pdftable2csv.py python script which can be downloaded from here

This command will convert PDF tables into csv file:

python C:\Python27\Scripts\pdftable2csv.py 2 CDE-Report1.pdf CDE-Report1.csv

Where “2” is the distance multiplier after which a character is considered part of a new word/column/block. Usually 1.5 works quite well

Is done by using “External application” Package Action:

QPDF.exe is here to help

qpdf -password= –decrypt test.pdf test1.pdf

Note: Some pdf files are actually encrypted with empty passwords

Advanced ETL Processor Professional and Enterprise Documentation
Visual Importer ETL Professional and Enterprise Documentation

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • knowledgebase/extracting_data_from_pdf_tables.txt
  • Last modified: 17/09/2018 09:45
  • by admin