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