match

This function checks if the given two strings are the same and returns TRUE if they are, FALSE if they are not.

For example, match("abc", "abc")==TRUE and match("abc","b")==FALSE.

Parameters: string1, string2

The following formula uses the match function to check if the field value contains a "-" character.

You can also use the wildcard characters in formulas, for example, match ("aabc", "*b*")==TRUE