IsMatch

Description of formula:
Checks whether text matches specified pattern.

Syntax:
ismatch(text, patern)

or
ismatch(text, pattern, ignoreCase)

Parameters:

text (type:Text)

Text to be checked against pattern

pattern (type:Text)

Pattern in form of regular expression

ignoreCase (type: Logical value)

Decides whether to ignore case or not

Returned type:

Logical

Examples:

=isMatch('Text', '[0-9]+') - checks if text contains at least one digit

=isMatch('Text', '^[0-9]+$') - checks if given value in first argument contains only digits

=isMatch('Text', '^[A-Z]') - checks if text starts with capital letter

=isMatch('Text', '^[^ąćęłńóśżź]*$') - checks if text don't have any Polish characters

=isMatch('01-123', '^[0-9]{2}-[0-9]{3}$') - checks if 01-123 is in postcode format