/
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 |
---|---|---|
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” |
/^([a-zA-Z0-9._%-]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,6})*$/ | “email@example.com“ “email@subdomain.example.com“ |
, multiple selections available,
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