MS.REGEXTEST
Description
Checks if text within a string matches a specified regular expression pattern and returns TRUE if there is a match and FALSE if there is not. This function is the same as REGEXTEST.
This function is useful for validating data against specific formatting rules or identifying strings that contain certain patterns.
Syntax
MS.REGEXTEST(
text
, pattern
, [case_sensitivity
]) - text: The text or cell reference containing the text you want to match against.
- pattern: The regular expression that defines the pattern of text you want to match.
- case_sensitivity: A number that determines whether the match is case-sensitive. Options include:
- 0 (default): Case-sensitive.
- 1: Case-insensitive.