Common Patterns

This is a short list of common patterns that can be used to restrict field data, provided only as an introduction to the many uses of regular expressions to ensure proper data formatting. These, like any other patterns, can be modified to best suit the needs of your organization.

Note:  These common patterns primarily use abbreviations for simplicity. However, you may also use any supported symbols when setting up a constraint.

Common Character Constraint Patterns

Type Pattern Example
Phone Number

((xxx) xxx-xxxx format)

\(\d\d\d\) \d\d\d-\d\d\d\d (562) 988-1688
Phone Number

(xxx-xxx-xxxx format)

\d\d\d-\d\d\d-\d\d\d\d 562-988-1688
Social Security Number

(xxx-xx-xxxx format)

\d\d\d-\d\d-\d\d\d\d 123-45-6789
Zip Code

(xxxxx or xxxxx-xxxx format)

\d\d\d\d\d(-\d\d\d\d)? 90807

Or:

90807-1234

Note: The Laserfiche Windows client will not provide a visual indication of the format for patterns that use optional characters, such as the Zip Code field in the example above.

Common Numeric Constraint Patterns

Type Pattern
Four-digit number >=1000 &  <=9999
Positive numbers only >=0

Note: The Laserfiche Windows client does not provide visual indication of numeric constraints.