Regular Expression
Regular Expression Usage
Regular expression can be used in column validation to validate and restrict user input. Eg. matching emails from specific domains, matching numbers within a specific range, matching a word or a phrase in a list etc...
Your regex should start with ^ and end with $ and match the whole input if it's valid.
Regular Expression Guides
- MDN Web Docs - Regular Expressions
- Regex101 - Test out your regular expression
Regular Expression Examples
These examples can be copied and pasted into your UseCSV Column Regular Expression Validation settings.
| Description | Match any email address from mydomain.com |
|---|---|
| Regex | ^[\w.\-]+(@mydomain).com$ |
| Description | Match word or phrase in a list: cat | dog | hamster | goldfish |
|---|---|
| Regex | ^(cat|dog|hamster|goldfish)$ |