REGEXMATCH
Description
Evaluates whether a substring exists in a string, based on the specified regular
expression. If the function finds the substring, it returns TRUE; otherwise, it
returns FALSE.
Syntax
REGEXMATCH(
text
,
regex
, [
ignore_case
])
- text: The text to search.
- regex: The regular expression.
- ignore_case: If TRUE, the function ignores case when searching. If FALSE, the function considers case. The default is FALSE.
Example
Formula | Result | Notes |
|---|---|---|
=REGEXMATCH( "hello world", "el+") | TRUE | Does the text contain the string "el"? |
=REGEXMATCH( "12-OCT-2015", "\d\d-[A-Z]{3}-\d{4}") | TRUE | Is the date formatted correctly? |
=REGEXMATCH( "7", "^\d+$") | TRUE | Is the integer positive? |
=REGEXMATCH( "-7", "^-\d+$") | TRUE | Is the integer negative? |
Related Functions
REGEXFIND
REGEXPARSE