Blank Fields

[Tim]

I'm new to Monarch, so please excuse me if this a simple question.

I have imported a report and am creating a template. Some of the fields in the report do not contain data and thus the whole record is being ignored.

Hod do I trap a field with blanks and alpha characters?

TIA

Tim

[Mike Urbonas]

Originally posted by Tim:
I'm new to Monarch, so please excuse me if this a simple question.

I have imported a report and am creating a template. Some of the fields in the report do not contain data and thus the whole record is being ignored.

Hod do I trap a field with blanks and alpha characters?

TIA

TimSpend a little time with the Learning Guide on trapping using blanks, alpha, numeric, numeric OR, and non-blank characters.

When you are in the Report view, creating a model template, you will see some buttons with these symbols on them:

à = Alpha trap - means look for report lines with an alpha character at this location in the trap
Ñ = Numeric trap - same as above, except for numeric characters
ß = Blank trap - means look for report lines where there is a blank space at this location in the trap
Ø = Non-Blank trap - opposite to Blank trap, look for ANY character in this location in the trap
| = Numeric OR trap - when you know a number will appear in one place "or" the other, use this kind of trap

The time you spend with the Learning Guide and/or Help file to understand these kinds of traps to mine the data from your reports will repay you many times over!

Mike