How To Construct a Validation Rule for Numeric Fields
The available pattern symbols for constructing numeric validation rules are
- digits used to form specific numbers. Numbers indicate value(s) to which the input data must conform.
- +, – used to specify the sign of a number.
- period used as a decimal point.
The available syntax characters for constructing numeric validation rules are
– | Denote a range of numbers. |
| | Separates alternative numbers or ranges of numbers. |
Examples of Numeric Validation Rules
The following table contains examples of numeric validation rules, and the values that can be legal or illegal under those rules:
Validation Rule | Legal Value | Illegal Value |
1|2|3|5 | 1 or 2 or 3 or 5 | 0 or 4 or 6 |
10-20 | From 10 to 20, inclusive. 10.123 is also legal. (Use DataMask to control the number of decimal places permitted in the field.) |
0-9 or 21 |
10-20|100-200 | From 10 to 20, or from 100 to 200, inclusive | 0-9 or 21-99 or 201 |
-30–5|1|1.3-1.7 | From -30 to -5, or 1, or from 1.3 to 1.7 | -4-0 or 1.8 or 2 |