This file appears to be a comma delimited file which would lend itself to be opened as a database instead of a report.
I took your sample and was able to open it successfully as a database in Monarch without converting it to Excel or any other type of file.
Give that a try and let us know how it fared.
,2012-09-10T00:00:00,VR 00003628-001,,AA.3620.415,PROPERTY MAINTENANCE: TO BE CHARGED TO TAXE,S,0,408
,2012-09-10T00:00:00,VR 00003629-001,,AA.3620.415,PROPERTY MAINTENANCE: TO BE CHARGED TO TAXE,S,0,125
,2012-09-10T00:00:00,VR 00003630-001,,AA.3620.415,PROPERTY MAINTENANCE: TO BE CHARGED TO TAXE,S,0,125
,2012-09-10T00:00:00,VR 00003605-001,,AA.7110.430,PK. - LANDSCAPING,,0,1000
,2012-09-10T00:00:00,VR 00003611-001,,AA.7110.430,PK. - LANDSCAPING,,0,1875 /CODE
I'm assuming that the first line is some sort of append record with customer details, and that the other lines are the detail lines of the work done for that customer? In which case, reading it as a database won't help, as you lose the ability to specify different templates for the different types of line.
What if you trap on NNNN.NNN, - that's picking up from the 7111.430 data which appears just before the data you want?
Yes, I need to create templates, so I tried the NNNN.NNN and it worked as other things have until halfway down the file the data creeps into the column on the right and then other columns data move a little to the left.
So that's why I was thinking of a floating trap.
I tried to save the PDF it origianlly came in as a PRN to line up the columns but that does not seem to be available.