Field and Rule construction
Fields and rules are modified via Properties icon (for the selected field only) or Rules and other area properties (all fields and rules).
Field properties are entered through this window:
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.