My first response is to suggest checking the file for spurious Carriage Return and Line Feed characters at the points where the lines split. (I think the post has lost a little in the posting so not sure exactly what you get for format). You may be able to use the MSRP utility to correct the file before submitting to Monarch - but then again maybe not.
Plan B (based on what I can Cut and Paste from the posting) would be to trap on the Alpha and 3 numeric at the beginning of a detail line, make the entire line a single field and a multi line field as well using "end field on" - 'minimum action'. Again this makes some assumptions about the format of the data row.
Then split it up again as required, probably using LSPLIT or RSPLIT functions and so on.
The section of report presented does not seem to have a regular pattern (space delimited fields?) and the second line/3 line split, when dealt with as described, includes an extra space in the number. This maybe just an edit problem? If it is a real problem we will need to derive a way to work around it.
There may be other approaches but I would like to know if the real output is exactly as posted before looking into them. In this case it is important to know.
Hope this helps.
C0165 CERAMICS LTD 2364.96 0.00
5 DECORACI 1779.72 25.00
D0075 THE0DENB 1918.99 391.54
E0006 GEORGE01 0.00 0.00
E0029 ENERGIZE 19.34
here two lines have jumped a) at the fourth digit of the second record and b) again at the last field of the last record. Has anyone any ideas how this might be overcome or any suggestions on the easiest way to edit to source document so that it extracts out easier. Most of the source documents worked with are formatted for wide listing paper.
Thanks in aniticpation
[size="1"][ July 09, 2003, 08:11 PM: Message edited by: Grant Perkins ][/size]