...
A Regex error message can also be defined. This will fire as a query if the data entered does NOT match what the expression requires. Here’s an example:
...
RegEx Examples
Objective | Expression |
|---|---|
Only enter numeric characters 0-9 with a maximum limit of six characters | ^[0-9]{1,6}$ |
10-digit phone number with hyphens | ^\d{3}-\d{3}-\d{4}$ |
Memo
The Memo Field allows for the storage of large amounts of alphanumeric information. Some typical uses for this data type would be notes, comments, or descriptions.
...