PowerUp Description
The pwrISREGEXMATCH PowerUp function scans a string for a match of the provided regular expression and returns TRUE if found and FALSE otherwise.
PowerUp Syntax
pwrISREGEXMATCH(value, expression)
The pwrISREGEXMATCH PowerUp function has the following arguments:
value – Required. This is the source text to be searched by expression.
expression – Required. This is the regular expression to be used to find a matching pattern of text within value.
Return Value
pwrISREGEXMATCH will return TRUE is matching text is found. FALSE will be returned if no match is found.
Remarks
None.
Example
=pwrISREGEXMATCH(A1,"[a-zA-Z]")
This function returns text strings for “TRUE” or “FALSE”, not true/false typed data. In order to use the output in other Boolean functions like OR(), AND(), NOT(), you have to do the following:
=if(pwrlSREGEXMATCH(text,regex)=”TRUE”, TRUE, FALSE).