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|