PDF version of this page

Field and Rule construction

Fields and rules are modified via Properties icon Properties Icon (for the selected field only) or Rules and other area properties (all fields and rules).

Field properties are entered through this window: Field Properties

Normalize is the RegEx used to reformat input data to the XML field. Predefined expressions are provided, and you can include your own. Data is normalized in the output XML file. The three most used Normalizations are:

Remove leading zeroes - used for records mode raw data - removes leading spaces and zeroes - retains one zero if the field is all zero.
Negative number - used to rationalize various forms of negative to a common "negative sign leading" format.
Trim numeric - used to trim spaces from numerics, including substitution of 0 (or 0.00) if the field is empty.
Trim - trims leading and trailing spaces from the data - use for text data to avoid doing this at form design time. This is required for fields used as substitutions.

More information on RegEx hints
More information on RegEx expressions for download

Note: FormTrap does NOT support RegEx under the Support and Upgrades contract, help with or generation of custom RegEx expression is chargeable. New expressions may be added from time to time by FormTrap to the download list on the website.

Parser Type is the type of data content and defaults to Text. Number, Currency, Percent and Date recognize data and for Date require Pattern. Pattern defines what the data parser looks for. For Dates, use these to recognize data:

d one or two digit day
dd two digit day
M one or two digit month
MM two digit month
MMM Month three character literal in Locale notation, case does not matter - eg Jun
MMMM Full month literal in Locale notation, case does not matter - eg June
yy Two digit year
yyyy four digit year

Parser Type and Pattern are accessed by Form Design for representation of dates and numbers.

Top