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:

  • JOHN
  • LORRAINE
  • RODNEY