Do you always have at least one blank line between records?
If yes then use a 2 line sample for your template. Define the probably field on the second row. It wll be populated with characters or blanks according to what is there.
If there are no blank lines OR a variable number of real lines between records a different approach will be required.
What does the field on the second row relate to? Anything to do with the trans# ?
I am using Monarch Pro V7. Please take a look at the 3 records below. 2 of the 3 have the transaction number go to a second line. How do I create a trap for this situation?
/size[list][*]cus# pay# trans# gldate[/size][/list]
/size[list][*]100 5222 TEST001 11-Dec-04[/size][/list]
/size[list][*]200 3999 INVOICE900 12-Dec-04
/size[list][*]95 29999 INVOICE500 13-Dec-04
The second transaction # is INVOIE9002-R
The third trans # is INVOICE500M200
Thanks in advance,
On the basis that the extra line should be part of the transaction number field (did I understand that correctly?) make the trans # field a multi line field using the Advanced Field Properties to END the field on "None of the Above". That should work in this case but try the others as well so you can see the different effects.
That should do the job but come back to us if there are any more issue to resolve.
Hope this helps.
My example is not lining up correctly. The second and third records should have 2-R and M200 in the transaction number field.