Hi, I'm very new to Monarch so there may be something here which is blindingly obvious to everyone else, but i'm not getting it.
I've got a pdf file which i've bought into Monarch (v8.02), set up traps and created field properties for the containing data through a template. The problem i'm having is that the report is extracted from a source which doesn't store the data nicely. For example, if a sale contains more than one item, the items will be put into one record rather than multiple records. Monarch reads this fine, it puts the extra info such as a product on a new row. Problem with this is that the report window doesn't show any info preceding the additional stock numbers. Also when i add a few traps it misses the numbers i need, such as stock and product numbers. This could be due to the first column, which should contain the main reference number, being blank. Actually all but stock and product columns are blank. With some though the numbers will be picked up but will be put in the same field box as the previous number from that field, but i need these as seperate records.
What i'd like to do would be to take the data as it is, and if there are some missing fields, but the row as a whole isn't empty, then for the field above to be copied. I've tried the empty cells option in the field properties but i can't get it to do anything. If someone wants to tell me how to use it properly if it can fix this problem i'd be grateful. The data below is purely as an example. I've asked already if i can show even some modified data, so that no one would know what the original was, but i'm still not allowed. Some very much faked example data is all i can show. This would be an example of the report window, with the data below being in a Detail template.
Salenumber Stocknumber Product Price Supplier
123/34 S3456 RayGun 19.99 Sony
129/45 P43rw Shield 24.99 Philips
F42354 Tortoise Hyundai
So the above would either not show the third line in the table window or it would add the numbers on to the previous numbers, so the p43rw field would actually show p43rw F42354. There isn't a character among these fields which is shared, nor is there any uniform field size. I've used the floating trap which gets the info i want, but it stores F42354 as a salenumber, Tortoise as a stocknumber and Hyundai as a product. The floating trap is just looking for where it can put the field for the salenumber, rather than what field the stocknumber is below, which is how i thought it would work. The other traps in use are a blank trap (to the left of the first sale number) and a non-blank trap (above the first sale number).
I'd be very grateful for any help you can give.