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

18 junho 2020

Updated11 junho 2022

ByJason Lee

Was this article helpful?