Using wildcard characters for filter values
Wildcard characters
When you define a filter value with the condition Contains or Does Not Contain, the value can include the wildcard character combination .*. This character combination represents any number of any character.
If the condition is other than Contains or Does Not Contain, the value cannot include the wildcard character combination .*.
Example
This table illustrates the usage of wildcards in a filter.
| Session | Employees - General (tccom0101m000) | |
| Field Name | Employee | |
| contains | AA | contains AA |
| doesn't contain | AA | does not contain AA |
| contains | H.* | starts with H |
| doesn't contain | H.* | does not start with H |
| contains | .*O.*N.* | contains O and, one or more positions later, N
Sample matches:
|