Whether a piece of text matches a regular expression.
Sample Usage
REGEXMATCH("Spreadsheets", "S.r")
Syntax
REGEXMATCH(text, regular_expression)
-
text
- The text to be tested against the regular expression. -
regular_expression
- The regular expression to test the text against.
Notes
- Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching. Learn more on how to use RE2 expressions.
- This function only works with text (not numbers) as input and returns a logical value, i.e.
TRUE
orFALSE
, as output. If numbers are used as input, convert them to text using theTEXT
function.
See Also
REGEXEXTRACT
: Extracts the first matching substrings according to a regular expression.
REGEXREPLACE
: Replaces part of a text string with a different text string using regular expressions.
SUBSTITUTE
: Replaces existing text with new text in a string.
REPLACE
: Replaces part of a text string with a different text string.