I have a quick question. I am opening a report in Monarch without a model and it is cutting of the last 35 or 40 characters of the last record. Looking at the original file there is data in those last 35 or 40 columns of the last record.

Here is some detail about the file. It's .txt, has around 41,000 records and 397 columns.

I discovered this when I was using a model against this file and exporting the file, the system that was picking up the file was erroring out.

Sometimes text files (presumably 'wrapped' onto more than one line per single record in the input file for Monarch) do not have an end of line or end of file 'marker' that Monarch recognises at the end of the very last line. The last line but one is recognised.

Could this be the case here?

If you edit a test copy of the txt file to add an extra line - a single character will do - do you get your data?

(I am assuming you are using 'character' and 'columns' interchangeably in your description so that your record length is 397 in total.)

Examine will tell you what strange characters might be causing the problem. You might find that in Monarch, editing the Input settings in the Options menu so that Monarch ignores non-printable control characters would also help.

If you have 397 columns of data, as opposed to a report 397 characters wide, then we have a different issue, as Monarch only supports 254 fields in any model...