The following symbols must be used to create
text patterns for text fields.
Note: The comma (,), dash (-), colon (:), slash (/),
period (.), and space ( ) are treated as literal values and can
be included anywhere in a pattern. To include a phrase in a pattern,
delimit the text string with single quotation marks ('). For example, 'Your phone number is ('999')' 999-9999 can
be specified as the Display Pattern.
Text symbol
|
Description
|
Example
|
|
Single alphabetic character
|
Display Pattern: A9A 9A9
Input Value:
K1S5K2
Formatted Value: K1S 5K2
|
|
Single character
|
Display Pattern: XXX XXX
Input Value:
!1$5&2
Formatted Value: !1$ 5&2
|
|
Single alphanumeric character
|
Display Pattern: OO OO OO
Input Value:
123ABC
Formatted Value: 12 3A BC
|
|
Single alphanumeric character
|
Display Pattern: 00 00 00
Input Value:
123ABC
Formatted Value: 12 3A BC
|
|
Single digit
|
Display Pattern: 999-9999
Input Value:
9407000
Formatted Value: 940-7000
|
Note: The O (capital “o”) and 0 (zero)
symbols are intentional synonyms in recognition that these two characters
are often mistyped and misread.
Reserved symbolsThe
following symbols have special meanings and cannot be used as literal
text.
Symbol
|
Description
|
|
When submitted, the symbol matches any one
character. When merged for display, it becomes a space.
|
|
When submitted, the symbol matches 0 or
Unicode white space characters. When merged for display, it becomes
a space.
|
|
When submitted, the symbol matches one or
more Unicode white space characters. When merged for display, it
becomes a space.
|
|
|
|