REGEX(S1, S2)

 

Description

This function returns true (1) if the string S2 matches the pattern specified by the regular expression in string S1, and it returns false (0) otherwise.  This function is similar to EXACT except it allows "wildcard" comparisons by interpreting S1 as a regular expression.

 

Refer to Regular Expressions for more information on this topic.

 

Parameters

 

S1

A string value.

 

S2

A string value.

 

Examples

 

REGEX("t.p", "top") = 1

 

REGEX("t.e", "table") = 1

 

REGEX("t.e", "talk") = 0

 

REGEX("F[0-9]", "F3") = 1

 

REGEX("F[0-9", "F3") = #Error

Missing ].

 

REGEX("a", "apple") = 1

 

REGEX("ab", "apple") = 0