Patterns

Parameters can be based be a "pattern". A pattern defines a condition that must apply for data to be included in your output.

The following conditions must apply:

•The pattern must match the value being checked to match for all non-special characters. For instance, the pattern 'John' matches solely the value 'John'.

•The special underscore character ('_') matches any characters. For instance, the pattern 'J_hn D__' matches 'John Doe' and 'Jahn Dim'.

•The special percentage character ('%') matches any sequence of characters, including the empty sequence. For instance, the pattern '%John%' matches 'John Doe', 'Carol and John Doe' and 'Me, Myself and John'.