Hi bmartuch. Welcome to the forum.
Using your sample, I built two templates: the detail, and a page header.
For the detail template, using a one line sample, I simply trapped on a numeric vendor number, and painted the fields. I named the Vendor information "A" and on the Advanced tab, selected End Field on "End of left Justification".
For the page header, I trapped on "PREPARED" for a 7 line sample. I did not paint any fields to capture, however.
The page header template being defined helps Monarch to know that the lines that follow, if they don't match the detail (or append) template definition, belong to the last detail record. In your sample case, that means that "THAT CITY" belongs to vendor 14.
Then in the Table window use the Address block on field A as described in the tutorial. This should get you to:
COMPANY A 3649 STREET A CITY, MI 99999 99-9999999 55555.26 5 COMPANY A 3649 STREET A CITY MI 99999 0
COMPANY B DRAWER #88888 PO BOX 44444 OLD CITY, MI 55555 88-8888888 6666.21 12 COMPANY B DRAWER #88888 PO BOX 44444 OLD CITY MI 55555 0
COMPANY C 6666 STREET C NEW CITY, MI 55555 77-7777777 55555.19 13 COMPANY C 6666 STREET C NEW CITY MI 55555 0
ANOTHER COMPANY 7901 BIG STREET THAT CITY, MI 33333 66-6666666 222.78 14 ANOTHER COMPANY 7901 BIG STREET THAT CITY MI 33333 0
COMPANY 555 DRAWER 698569 PO BOX 44444 OLD CITY, MI 5555 88-8888888 7777.77 18 COMPANY 555 DRAWER 698569 PO BOX 44444 OLD CITY MI 55555 0
Kruncher, that got pretty close but some of them are still wrong. For Company B,
Drawer #88888 /Bis correctly in Address 1
There is nothing in Address 2
Obviously, I'm still doing something wrong.
First, make sure that your inital field is wide enough. I've got the template width for the field set at 20.
With the Address Block, I selected the first three address lines, City, Region, Postal Code and Error Code.
It's a good practice to always include the error code. Then it's easy to double-check Monarch's work (it's good, OK very very good, but not always perfect) by creating a filter for ErrorCode<>0.
Is that any better for you?
After much searching to find out what the bad records had in common, I finally found it. They all had improper formatting on the zip codes. Instead of Zip+4 looking like 99999-9999, it looked like 99999-999. Either the data was entered into the system where someone entered the dash in a field that was only meant for 9 digits or the report only displayed 9 characters. On one of the reports, I deleted the last four characters of the zip code to see if that would solve the problem and it did.
Thanks a lot for all of your help. I wouldn't have known to set the End of Field to "End of left Justification" on the advanced tab.