Index Field Validation Masks
You define a validation mask to verify that all data entered (automatically or manually) in an index field is correct before a batch is exported. If the data does not match the mask you select, the index field is considered to be invalid. You must correct the value manually so the batch can be exported successfully.
For example, suppose that you define an index field value that combines the year with {Bar Code 1}, which includes INV followed by eight digits:
{ScanYear4}"-"{Bar Code 1}
In this case, you would set up the following validation mask:
YYYY"-INV"9(8)
If the bar code is not detected successfully due to damage or another reason, the validation process does not accept the value. In this case, you manually enter the bar code value during the indexing process.
The table lists the validation masks that are available when you click the setup tool next to the Validation field on the Index Setup tab.
If you are using Database Lookup to configure index fields, validation is not available for the index field associated with the primary lookup field. You can apply a validation mask to index fields associated with lookup fields related to the primary lookup field.
Validation Masks
|
Index Field Validation Mask |
Description |
Sample Result |
|---|---|---|
|
Clear |
Clears any existing index field format entry |
None |
|
? - Any character |
Alphabetic, numeric, or special characters are accepted |
3 or C or ! (0-9 or A-Z or a-z or any special character) |
|
A - Alphabetic character |
Alphabetic characters are accepted |
C or c (A-Z or a-z) |
|
X - Alphanumeric character |
Alphabetic or numeric characters are accepted |
3 or C or c (0-9 or A-Z or a-z) |
|
9 - Numeric character |
Numeric characters are accepted |
3 (0-9) |
|
?(5) - 5 Any characters (replace 5 with any number) |
Any 5 characters, where 5 is replaced with the desired number of characters |
3!TRC |
|
A(5) - 5 Alphabetic characters (replace 5 with any number) |
Any 5 alphabetic characters, where 5 is replaced with the desired number of alphabetic characters |
CCTRC |
|
X(5) - 5 Alphanumeric characters (replace 5 with any number) |
Any 5 alphanumeric characters, where 5 is replaced with the desired number of alphanumeric characters |
33TRC |
|
9(5) - 5 Numeric characters (replace 5 with any number) |
Any 5 numeric characters, where 5 is replaced with the desired number of numeric characters. |
33457 |
|
Date |
||
|
DD"-"MM"-"YYYY-Date |
Scan date must be expressed as DD"-"MM"-"YYYY format |
18-04-2013 |
|
{DDMMYYYY} - Date |
Scan date is the default value expressed in DDMMYYYY format |
18042013 |
|
{MMDDYYYY} - Date |
Scan date is the default value expressed in MMDDYYYY format |
04182013 |
|
{YYYYMMDD} - Date |
Scan date is the default value expressed in YYYYMMDD format. |
20130418 |
|
{JJJ} - Julian day of year (001 - 365/366) |
Three-digit representation of the scan date in Julian date format in the context of a year |
109 |
|
{YYJJJ} - Julian date |
Scan date in Julian date format; date is expressed as a 5-digit abbreviation that represents the year and the day. |
13109 |
|
{DD} Day of month (01 - 28/29/30/31) |
Two-digit representation of the day associated with scan date |
18 |
|
{DDD} Day of week (Sun - Sat) |
Three-character abbreviation for the day of the week associated with the scan date |
Fri |
|
{MM} - Month (01 - 12) |
Month associated with scan date expressed as a 2-digit abbreviation. |
04 |
|
{MMM} Month (Jan - Dec) |
Month associated with scan date expressed as a 3-letter abbreviation. |
Apr |
|
{YY} - Year (short) |
Year associated with scan date expressed as a 2-digit abbreviation that excludes the century |
13 |
|
{YYYY} - Year (full) |
Year associated with scan date expressed as a 4-digit abbreviation that includes the century |
2013 |
|
Time |
||
|
HHmmss - Time (24-hour format) |
Scan time expressed as a 6-character format that represents hours, minutes, and seconds in the context of 24-hour increments |
232133 |
|
hhmmsstt - Time (12-hour format) |
Scan time expressed as an 8-character format that represents hours, minutes, seconds, and time of day in the context of 12-hour increments |
112133PM |
|
HH - Hour (24-hour format) |
Two-digit representation of the hour in the 24-hour format |
23 |
|
hh - Hour (12-hour format) |
Two-digit representation of the hour in the 12-hour format |
11 |
|
mm - Minute (00-59) |
Two-digit representation of the number of minutes |
21 |
|
ss - Seconds (00-59) |
Two-digit representation of the number of seconds |
33 |
|
tt - AM or PM |
Time of day expressed as AM or PM |
AM |