REGEXMATCH

  • Updated

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.