Excel tool to parse OCRed PDFs

Excel VBA tool to parse multiple large OCRed PDF documents into CSV files. SQL queries used to get data from source files fast and  w/o opening the files in Excel. Regular Expressions used to split data into rows and columns, to verify data formats, to remove trash characters, to fix OCR errors. The tools is able to detect and fix multiple OCR errors or highlight and log record...
Read More

Converting PDF files to Excel

We convert scanned and searchable PDF files to excel. We prefer to use VBA programming and advanced custom excel functions to do pdf to excel converting job fast and with 100% accuracy. If you have 1000 pages pdf document (with similar structure of all pages) we will just create a program to process first page and then we will be able to process all document in one click. No ma...
Read More

Advanced Excel Formulas to Split Names, Addresses and Phones

We use advanced excel formulas with custom vba programmed functions to split string data into columns. For example to split string with names and phones to First Name, Last Name and Phone columns: [swf:http://xlbin.com/wp-content/uploads/2012/02/aefsnp.swf 595 359] http://xlbin.com/wp-content/uploads/2012/02/aefsnp.swf Advanced excel formulas also can be used to split addre...
Read More