match()
match(value,RegExp) provides a more sophisticated way than WildCharMatch() to compare two strings. Any comparison that can be expressed through Regular Expression can be used.
Note: Knowledge of the Regular Expression language is a
requirement for working with this function.
match() examples
Following are some WildCharMatch() usage examples:
match(form.company,’1[0-9a-zA-Z]*4’)
Retrieves all companies that start with “1,” end with “4,” and are of any length.
match(form.company,’12[0-9a-zA-Z]4’)
Retrieves all companies that start with “12,” end with “4,” and are four characters in length.
match(form.company,('1[0-9]*4')
Retrieves numeric strings that start with "1," end in "4," and are of any length.
This example would retrieve "111212322324" but not "1dada3232324."