/
Common Patterns

Common Patterns

The following useful regular expression patterns can be used or adapted to your specific needs in GlobalSearch, GlobalCapture, or GlobalForms.

Name

Pattern

Example

Name

Pattern

Example

US Date

(0?[1-9]|1[012])([/-])(0?[1-9]|[12]\d|3[01])\2(\d{4})

“01/01/1997” “4/3/2010”

US Phone

\(?[0-9]{3}\)?\s?[0-9]{3}-[0-9]{4}

“203 789-0889” “(203) 789-0889”

URL

(https?://)?([\da-z.-]+).([a-z.]{2,6})([/\w .-])/?

“www.square-9.com” “https://www.google.com”

USD Amount

$?[0-9]{1,3}(?:,?[0-9]{3})*.[0-9]{2}

“$100.98” “3,182.99”

Email

/^([a-zA-Z0-9._%-]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,6})*$/

“email@example.com“ “email@subdomain.example.com“

 

Related content

Mitigating SQL Performance Issues
Mitigating SQL Performance Issues
Read with this
Pattern Matching using Regular Expressions
Pattern Matching using Regular Expressions
More like this
Pattern Matching using Regular Expressions
Pattern Matching using Regular Expressions
More like this
Extending the Sample Expressions list
Extending the Sample Expressions list
More like this
Regular Expressions for Fields
Regular Expressions for Fields
More like this
Manage Fields
Manage Fields
More like this