Thank Grey -
I forgot to add Amber to the list of pdf utilities I have tried
It outputs pretty much same as Able to Extract
I can probaly program around text
But negative values on the pdf as ( 200,000)
Are reading into excel as ( in col A and 200,000) in Col B
This of course just example
The right parend is all over the place
Do you know VBScripting?
Or have a resource?
One of my employees wrote a script that uses pdf2txt to convert the
pdf's to txt files Then extracts certain items from the txt file and outputs to
a tsv file.
Problems is it is not working 100% correctly and have lost contact with
the employee.
Output:
Unit Number || Label Descrip || Accnt Nmbr || Amount
xxxxxxxx || travel-airfare || 6542.0001 || 900.02
etc.
There are many lines of data in the file
I only need to output last line of each account at "Account Total"
The script works closely, but not perfectly
Sometimes some values are missed - randomly.
Report initiates as .pdf and is converted to .txt
All .txt reports are mereged into 1 report
The 1 report is then "stripped" based on the above parameters
Attachments:
mergefile.zip This is the source file. When I convert from pdf to txt I lose a little structure. I tried marking it up to strip with DataImport, but the columns move around a bit with each different profit center
FAR-Account_V3.txt this is the .vbs file, I simply renamed the extension
It will prompt for input path and file and output and file.
Thanks
-xcel