Need help trapping random lines

Altair Forum User

I am new to using Monarch V13 and having some issues choosing a template and trapping random lines... I am working with a text file.

 

Here is all I am having luck with. I've marked next to the data I want to trap. They need to be all within their own individual field per claim # and this data is random. If it helps me to send the file for you to play with, I'm more than happy to do so. I just can't get this down.

Thank you!

Altair Forum User

From your sample data I would create two new templates.  The first one would be a footer template (since it occurs after your detail line) that starts to trap on the line beginning with Serial#.  I would use a blank followed by a non-blank trap to capture the space before the "S" in serial # and the letter "S".  You would then create a field that captures the whole line.  Once you define the field, in template editor, edit the new field and select the advanced properties, and then end field on a blank field value of 1.  This will capture the lines you don't want at first.  You then create a new exclusion template that is 3 three lines long that starts on the beginning of the line with ">>>>".  This is assuming that everytime you see ">>>>" you want to exclude three lines.  If you can share the file, I can help with some more thoughts, but I hope this points you in the right direction.