ISREGEXEXACTMATCH

Syntax

ISREGEXEXACTMATCH (input, regex)

Description

Compares an input string to a regular expression and determines whether the expression provided exactly matches the whole input string. This function returns True if an exact match is found, or False if the match criteria are not met.

Arguments

input String to compare to the regular expression.
regex The regular expression pattern to match.

Returns

Returns True if the regular expression regex finds a match in the string input, and the match is equal to the whole input string.

Returns False if the regular expression regex does not find an exact match in the whole input string.

Remarks

For detailed information about using Regular Expressions, see the Microsoft .NET Regular Expression Language - Quick Reference.

Examples

ISREGEXEXACTMATCH ( “abc_def”, "abc.def" )

Returns: True

ISREGEXEXACTMATCH ( “abcdef”, "abc.def" )

Returns: False

Related Topics

Text Functions

FINDREGEX

MATCHREGEX

REPLACEREGEX