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?
Tim[/b][/quote]Spend 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!