[]
DEMOS BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

REGEXTEST

The REGEXTEST function allows you to check whether any part of the supplied text matches a regular expression ("regex"). It returns TRUE if it does, and FALSE if it doesn't.

Syntax

REGEXTEST(text, pattern, [case_sensitivity])

Arguments

Argument

Description

text

[Required] The text or the reference to a cell containing the text you want to match against.

pattern

[Required] The regular expression ("regex") that describes the pattern of text you want to match.

case_sensitivity

[Optional] Determines whether the match is case-sensitive.

0 – Case sensitive(default)

1 – Case insensitive

Remarks

Return: TRUE or FALSE. The regex test result.

Examples

REGEXTEST("abc","a") gives the result TRUE

REGEXTEST("abc","[A-Z]") gives the result FALSE

REGEXTEST("abc","[A-Z]", 1) gives the result TRUE

REGEXTEST("abc","[0-9]") gives the result FALSE

Version Available

This function is available in product version 19.0 or later.