Hi Karen. Welcome to the forum.
Is the 7.38 value for the 173737 record actually in its own line in the data file, or is that just a formatting issue in this post?
I guess I'm really asking if the DISCOUNTS item is the only 2nd line item that you want to tack on to the 173747 Irene Belfrey record, or if the 7.38 is one too. We can probably handle either case; I'd just like to clarify before we get going.
Thanks for the quick response. The 7.38 is actually farther over on the second line. The second line ALWAYS begins with blanks where normally there would be an account number. After that, it MAY hold the word "DISCOUNTS" or it might just be a lone number or two numbers such as the 7:38. If every second line contained the word "DISCOUNTS", it would be easier. But really, the only common denominator is the blanks where there would be an account number if it were a new record. The second line contains additional information relevant to the account, when it pertains, which isn't frequently. What I can say is that all number line up exactly.
What I'd like to be able to do is begin a new record when there is a value (non-blank) in the first column.
Monarch is fabulous, .... when I can get it to work. ANd I know there is a lot for me to understand yet.
OK, in order to extract this properly, you'll need to employ two append templates. Specifically, you'll need two [URL="http://********************/extract/experimentation-produces-monarch-success"]"guru trap"[/URL] templates. I'd recommend that you spend a couple of minutes reading the linked item before preceding below. It'll help to make sense of this.
Keeping things simple with your example, I built a detail template which had a single N in column 1, using a one line sample. Paint the field(s) as you would normally.
Now select the Discounts line as a sample, and for the trap, again use a single N in column 1 for the trap and paint the discount values as necessary. For each of these fields, on the Advanced tab specify that the word discount appears on the same line. Save the template.
Repeat this process for the 7.38 line, except that this time you'll specify that 4 spaces appear in the same line using the Advanced field properties.