Hallo Dietze and welcome to the forum,
If you could post an example of the output that you are looking for, it would be very helpful.
If you want get one row of data in Excel for each row of data in your text file, then use a simple "non-blank" trap in column one, and then define a field for the whole row and use lsplit(x;4;" ";1), lsplit(x;4;" ";2) to define the fields. You could also use the floating trap with the blank trap as the field boundary.
If you want some more complex summary, filtering or comparison of the data, please let us know!
Hello dietze63 and welcome to the forum.
I have read the dscription of your problem but I am not sure if you are using your template to make every line a detail record or have a multiple line data sample to make several lines combine into one record.
If you see the concatentated report as a series of multiple line records then you will need to make your sample lines for the template to be only as many lines as you see in your smallest record. If every record ends with a blank line or more than one blank line or some other constant but not data related characters you could include those lines in the sample as well.
For records that are bigger than the minimum number of lines you will need another template to extract the data. This is likely to be an APPEND template but may be a footer template. You may need several templates in some situations.
I think what you may be seeing in the Excel ouput is some sort of overlap of the templates where, perhaps, one template is longer than the number of lines for a specific records and so will also overlap the start of the next record. In this case Monarch will not 'see' the next record when extracting but the report screen would still highlight the fields defined in the template since it is not running a full extraction process example when indicating what your template definition is likely to do.
There are similar situations that can occur if you are using Append or footer templates.
If you are using single detail lines for the template sample then you have a different problem to the one I have written about above.
Does this help at all?