Skip to main content

Part of Data Landing Portal (DLP) data sender user guide

Appendix A - List of validation rules for each Rule type

Current Chapter

Current chapter – Appendix A - List of validation rules for each Rule type


 

Rule type Validation rules/characters allowed
Text  
Alpha [a-z] or [A-Z]. Allows for Spaces. Max length includes every 
single character and space.
AlphaNumeric [a-z] or [A-Z] or [0-9]. Allows for Spaces. Max length includes every single character and space.
AlphaNumericSpecials Any valid characters in the encoding set used. ASCII characters in the range 32-128 (https://www.danshort.com/ASCIImap). Max 
length includes every single character and space.
Number  
Integer 0-9 and allow "-” and “+” as prefixes. Thousand separators are 
valid ",". No decimal point. Max length only counts the number of numeric characters.
Decimal

0-9 and allow "-" and “+” as prefixes. Thousand separators are 
valid "," as is a decimal point.

Note: with a Decimal you can define both the maximum precision (mandatory) and scale (optional). The precision defines how many numeric characters the user can enter in total. (Characters such as commas do not count towards this total). The scale defines how many decimal places your number can have. The precision and the scale should be separated by a comma (e.g. 8,2 would allow the user to enter 8 numeric characters in total of which up to 2 can come after the decimal point).

The maximum precision allowed is 30. Where no scale is set, no 
validation is done on the number of decimal places (e.g. if a 
precision of 3 is set, valid entries could include 100 and 0.01).

Currency

As decimal but allow prefix of "£", "$", "€". Should accept even if 
no prefix is present, i.e. it is still a decimal

Note: the rules for precision and scale (described against the 
Decimal Data Type) also apply to Currency.

Date Validate as per original specified format
Time
Date Time

Last edited: 25 August 2021 4:09 pm