So I was able to resolve the truncating issue by uninstalling and re-installing Adobe Acrobat DC -- however now we have a new error.
When exporting to Excel Workbook (or XML Spreadsheet), the numbers show correctly, but all of the information is in one column. i.e. 55001 0015101820990791961357 $dollar amount 6758 etc (all in the same column... just one long text input)
as opposed to:
Column A Column B Column C
55001 0015101820990791961357 $dollar amount etc.
I'm not seeing any sort of settings that might control this... but any insight on this issue would be greatly apprciated.
I currently have a ticket open, and as far as I know, it has been escalated to Senior Tech Support.
I was able to workaround the single-column issue using Excel's 'Text-to-Columns' command, but there is a conversion issue from Acrobat DC to Excel, causing some of the information to be merged into the same line, i.e.:
gets converted to:
The letters from the 2nd line will end up mixed in with the numbers (or vise versa) from the 1st line, and they will appear as sub-script. This causes all of the data after that 'CCS' location to be jumbled up and in the wrong location, and then Excel has no idea where to put it, so every new piece of text gets placed on its own column, i.e.
12345 CCS $12.00 12345 TEXT DIR 1234
So, to re-organize, one would have to move each cell very carefully to its corresponding line, checking it against the original PDF to make sure it goes into the right place. Sort of defeats the purpose of trying to convert it to Excel.
I have sent you a private message.
Please go through it once.
I replied to your private message with the Adobe case number related to this issue.