Description
Check if any part of supplied text matches a regular expression and return True/False.
NOTE
- By default, REGEXTEST is case sensitive function and use the PCRE2 ‘flavor’ of regex.
- More syntax:
– Lookahead and Lookbehind: (?= … ), (?! … ), (?<= … ), (?<! … )
– Non-capturing group: (?: … ), disable capture groups: (?n)
– Atomic groups: (?> … )
– Named Capture: (?<name> … ) or (?P<name> … )
– Branching structure: (?| … )
– Inline comments: (?# … )
– ……………
Syntax
Copied!=REGEXTEST(text, pattern, [case_sensitivity])
EXAMPLE
Copied!//[𝘰𝘱𝘵𝘪𝘰𝘯𝘢𝘭]: 𝘤𝘢𝘴𝘦_𝘴𝘦𝘯𝘴𝘪𝘵𝘪𝘷𝘪𝘵𝘺=1[0,1] //𝘤𝘩𝘦𝘤𝘬 𝘤𝘰𝘯𝘵𝘢𝘪𝘯𝘴 𝘢𝘯𝘺 𝘯𝘶𝘮𝘣𝘦𝘳, 𝘳𝘦𝘵𝘶𝘳𝘯 𝘛𝘙𝘜𝘌 =REGEXTEST("Excel 365", "\d") //𝘤𝘩𝘦𝘤𝘬 𝘤𝘰𝘯𝘵𝘢𝘪𝘯𝘴 𝘥𝘶𝘱𝘭𝘪𝘤𝘢𝘵𝘦 𝘸𝘰𝘳𝘥𝘴 (𝘮𝘪𝘯𝘪𝘮𝘶𝘮), 𝘳𝘦𝘵𝘶𝘳𝘯 𝘛𝘙𝘜𝘌 =REGEXTEST("Adjust the minimum word length and minimum number of repeats using the sliders", "\b(\w+).*?\1\b") //𝘤𝘩𝘦𝘤𝘬 𝘱𝘶𝘯𝘤𝘵𝘶𝘢𝘵𝘪𝘰𝘯 𝘮𝘢𝘳𝘬𝘴 ('), 𝘳𝘦𝘵𝘶𝘳𝘯 𝘛𝘙𝘜𝘌 =REGEXTEST("I didn't believe it", "[[:punct:]]+")
| Username | Score | name |
| -------- | -----:| -------------- |
| Falcore | 1293 | Snow queen |
| Dunsby | 2342 | Jungunji queen |
| Habisham | 5234 | Hala queen |