I need to convert a .PDF document that contains tables into Excel or Word then write a macro to extract the data. The document is 36,000 pages. I have tried extracting a few pages then using some on-line sites to convert it. The results are not exactly right, and I don't want to spend days breaking the document into smaller pieces, although I might have to.
Can someone recommend some software to do this?
> If converted to plain text how would I know what data is what?
By column headings and/or the table layout. I would experiment with the -layout and -table options of PDFtoText (https://www.experts-exchange.com/videos/217/).
We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.
Nice table. Huge mess.
Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …