It sounds to me that you're missing a stage out - either prep the data using teh tools at:
or the tools included in the Monarch Utility.
Another way to deal with it is to treat the data as a database - if you have Monarch Pro. If you only have Standard, the upgrade's worth it, not just for this feature but for many others.
I'm with Olly on this one - I think you need to gain control of the report format using the Utility of stand alone programs unless you can read the csv file (and discard the unwanted columns) as a database. If there is anything funny going on in the file(s) provided these processes should help to identify what it is. (I have assumed you are not already using the database read option based on your probloem description.)
Things that might have an impact that are the result of the file format include the position of any file formatting characters (see and play with the Options settings to see if anything makes a difference to the results - just look for a difference rather than a correction at this point).
From the Monarch downloads web site there is also a program called EXAMINE which is very useful at times like these for seeing what is ini the file character by character.
Another possibility (maybe in addition to format issues) is that your trap does not work for all the files. Obviously it could fail if the report format was inconsistent at the position you are setting the trap but perhaps the data is also inconsistent compared to the trap rules? You don't say how you are setting the trap but working with a format like a csv file with potentially variable width fields can be prone to 'unexpected data' issues.
Let us know what progress you make - we may be able to offer further suggestions.
The Database route worked great. I used Open Database in stead of Open Report, selected the CSV file and the column headings that I needed and it created the Table. I tested it with multiple CSV files and it remains consistent.
Thanks for your help.
Good news Rick!
Glad you had Monarch Pro version available - it offers so much more flexibility than Standard for relativiely little additional investment. Much more for you to play with now you have seen the potential!