Batch PDF Data Extraction

Description
The bulk extraction of PDF information is designed to compile and consolidate multiple data points from many similarly structured PDF files in one process. Examples such as application forms, bank statements and survey data can result in many individual PDF files with the need to extract specific data from each.

The batch extraction works by specifying multiple rules for the text surrounding the content required to be extracted. Rule options include wild cards and line feeds. Results are structured in tabular form with the name of each file in rows and content extractions in columns.

The extraction tool uses and relies on a provided executable file which transforms the PDF into a plain text file. This file, as well as the extraction tool needs to be placed in the same file directory as the PDF files from which extraction is required. The process analyzes the folder and processes every PDF file that exists in it.

Additional options include to retain generated text files and append results to existing ones for iterative extraction routines.

The resulting output can be cleared if results are not as expected in order to modify the extraction rules accordingly. The VBA code is open for viewing and modification if required.