The edit mask rules options are:
Option |
Description |
---|---|
Mask |
Validates the data field against a predefined edit mask. |
EnforcementFrequency |
Specifies the frequency the rule will be enforced. |
EnforcementLevel |
Specifies the rule enforcement level. |
Edit Masks are used to verify numeric data such as amounts, Social Security numbers, or phone numbers. Or to maintain consistently formatted data by validating the layout of the data.
To limit the data field to a specific format, build a custom edit mask using the characters listed below.
Character |
Description |
---|---|
A |
Any alpha character only |
9 |
Any numeric character only |
X |
Any alphanumeric character |
@ |
Variable number of alpha characters only |
Z |
Variable number of numeric characters only |
* |
Variable number of alphanumeric characters |
$ |
Variable number of numeric characters only in an amount field (including commas) |
V |
Implied Decimal Point (inserts a decimal point) |
. |
Fixed Decimal Point |
Certain characters have specific meanings in an edit mask. Any other character in the mask denotes a literal character and is output as typed.
Examples of Edit Masks:
-
Social Security Number:
Expected output for a social security number = 114-26-7576
Edit Mask = 999-99-9999
-
Amount Field:
Expected output for an amount field = 123,123.00
Edit Mask = $V99 or ZV99 or z^99
-
Account Number:
Expected output for an account number = M537A264-22X
Edit Mask = A999A999-99A
-
Letter/Number Combinations:
Expected output = A31 or B2 or C127
Edit Mask = AZ
-
Number/Letter Combinations:
Expected output = 31A or 2B or 127C
Edit Mask = ZA