This post will guide you how to use Google Sheets REGEXMATCH function with syntax and examples.
Table of Contents
Description
The Google Sheets REGEXMATCH function is to check whether a piece of text matches a regular expression.
The REGEXMATCH function can be used to check whether a substring from a text string matches a given regular expression in google sheets. And it returns a logic value, TRUE or FALSE.
The REGEXMATCH function is a build-in function in Google Sheets and it is categorized as a Text Function.
Syntax
The syntax of the REGEXMATCH function is as below:
= REGEXMATCH (text, regular_expression)
Where the REGEXMATCH function arguments are:
- text -This is a required argument. The text string that you want to extract a substring based on regular expression.
- regular_expression – This is a required argument. The Regular_expression is a regular expression. It can be used to match the part of the text that you want to extract. The regular expression argument should be entered in double-quote characters.
Note:
- The REGEXMATCH function takes two arguments. It checks whether a piece of text matches a given regular expression.
- The REGEXMATCH function only works with text value as its first argument and returns a text result. If you wish to return a numeric value, and you need to use VALUE function in combination with the REGEXEXTRACT function. If the input value is a number, and you can use the TEXT function to convert them.
- Google Sheets supports RE2 for regular expressions.
Google Sheets REGEXMATCH Function Examples
The below examples will show you how to use google sheets REGEXMATCH function to extract a substring from a text according to a regular expression.
#1 Check if text value in Cell B1 matches a given regular expression, using the REGEXMATCH function with a regular expression “google” , type:
= REGEXMATCH (B1,"google") //it returns “TRUE”
#2 Check if text value in cell B1 matches either of the words in a sentence using REGEXMATCH function with a regular expression “google|sheets” , type:
=REGEXMATCH(B1,"google|sheets") // it returns “TRUE”
#3 Check if text value in Cell B1 matches any number of decimal digits using REGEXMATCH function with a regular expression “\d+” , type:
= REGEXMATCH(B1,"\d+") // it returns “TRUE”
#4 Check if text value in Cell B1 matches any specific decimal digits using REGEXMATCH function with a regular expression “[2-3]” , type:
= REGEXMATCH(B1,"[2-3]") // it returns “TRUE”
