Description | The |
Syntax | REGEX_MATCH( |
Output | boolean |
Variables
text
: The input text string you want to check for a pattern match.pattern
: The regular expression pattern to be used for the match check.
Example
REGEX_MATCH(`Phone Numbers`,"^[+]?[0-9]?[-. ]?\(?[0-9]{3}\)?[-. ]?[0-9]{3}[-. ]?[0-9]{4}$")
ID | Phone Numbers | REGEX_MATCH |
1 | (555) 555-5555 | true |
2 | 123-456-7890 | true |
3 | 800-555-1234 ext. 567 |
|
4 | +1 (123) 456-7890 |
|