How To Construct a Validation Rule for Numeric Fields

How To Construct a Validation Rule for Numeric Fields

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

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

 

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Leave a Reply

Your email address will not be published. Required fields are marked *

en_CAEnglish