7.5

A9A\ 9A9 ACanadian postal code
H0H 0H0
J0S 1J0
H1V 2C8
\$999\,999\.99
Dollar amount with thousand separator, up to $999,999.99 dollars. However, note that all char-
acters must be present, so the mask must be padded with zeroes (0) if the amount does not
fully fill each box (see examples)
$000,001.99
$321,443.54
$000,599.97
It is important to understand that these masks are very precise and will not accept any sort of variation. For example, the sec-
ond example (phone number with extension)will only accept a 3-digit extension. A 5-digit extension could not be entered with
this mask. Because the Multi-Area Field will automatically divide the field into boxes accepting one character per box, this is
made clear to anyone using these boxes.
Regular Expressions
If the data that is expected from the field can vary in contents as well as length, a Regular Expression can be used instead of a
Custom mask. Regular expressions are much more powerful but they can be difficult to understand at first. Note that a Regular
Expression mask will not automatically divide the Multi-Area Field into rows and columns nor will it print out static characters in
the field, since the number of characters can be variable.
Accepted Values
This documentation cannot pretend to teach anyone how to learn to use Regular Expressions nor to describe how to build reg-
ular expressions. Plenty of tutorials and documentation on Regular Expressions exist online. However, here are some quick
resources that may help you in building your expressions:
These links are provided for your education and are not supported or maintained by Objectif Lune Inc.. Use the infor-
mation provided by those links at your own risk.
l Regular Expressions Cheat Sheet , available in PDFand PNGformat
l Regular-Expressions.info tutorial.
Examples
These examples are similar to the ones in the Custom Mask but may extend upon them and accept a wider variety of results.
Regular Expression Description Examples
(\d{3})\D*(\d{3})\D*(\d{4})\D*(\d*)$
A fully featured expression for most phone number for-
mats used in the world.
work 1-(800)
555.1212 #1234
800-555-1212
80055512121234
PROD-[0-9A-Za-z]{5}-[A-Z]{3}-\d{5} Product Number
PROD-5G32B-ADE-
23643
PROD-IPHON-TGS-
16000
^\d{5}(-\d{4})?$ A5 or 9 digit USZip code with optional dash.
90210
32454-4332
^[ABCEGHJKLMNPRSTVXY]{1}\d{1}[A-Z]{1}
*\d{1}[A-Z]{1}\d{1}$
Avalid Canadian postal code.
H0H 0H0
J0S 1J0
H1V 2C8
©2010 Objectif Lune Inc - 171 -