Checks whether a string matches a regular expression.
Sample Usage
REGEXMATCH("Spreadsheet.com","read")
REGEXMATCH(A1,"abc")
REGEXMATCH(A1,A2)
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.
Examples
REGEXMATCH("Spreadsheet.com","read") returns TRUE, as a section of the text matches with the the regular expression "abc".
REGEXMATCH(A1,"abc") returns TRUE if the cell A1 matches with the regular expression "abc".
REGEXMATCH(A1,A2) returns TRUE if the cell A1 matches with the regular expression contained in cell A2.
Notes
- This function only works with text as input and returns text as output.