Code List Validator
In the Conditions box, type the appropriate code list conditions. The code list is a comma–separated list of the allowed values for this field. If the value of the field is not contained in the code list, errors will be generated.
Note:
This validator validates only in ascending order and according to the ASCII values.
You can specify three different types of code lists:
Simple Code List. A comma separated list of valid codes.
Range List. A range list, which can occur within any type of code list, validates that a string value is between a given start string and end string. The range is specified as
start string:end string. Values are considered to be valid for a given range if all of the following conditions are true:
The value is the same length as the start and end strings of the range.
The character value in the same position in the start and end string comes from the same character set (a–z, A–Z or 0–9).
The value is lexically greater than or equal to the start string and lexically less than or equal to the value of the end string.
For example A0:Z9 is valid, because the first character of each string comes from the set A–Z, and the second character of each string comes from the set 0–9. A2:2B is not valid because the first character of the start string does not come from the same character set as the first character of the end string.
Partition List. A partition joins together multiple code lists within one field, separated by a pipe (|). For example, if you enter
ABC,DEF|1,2, the allowed values of the field are ABC1, ABC2, DEF1, and DEF2. Each set of code lists must have the same number of bytes.
The code list validator allows for the right hand side of the partition to be optional. For example, if you enter ABC,DEF|1,,2, the allowed values of the field are:
ABC1, ABC2, ABC, DEF1, DEF2, and DEF.
The extra comma in 1,,2 indicates that the values 1 and 2 are optional.