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.

SessionEmployees - General (tccom0101m000)
Field NameEmployee
ConditionValueDisplays all employees of which the Employee field:
containsAAcontains AA
doesn't containAAdoes not contain AA
containsH.*starts with H
doesn't containH.*does not start with H
contains.*O.*N.*contains O and, one or more positions later, N

Sample matches:

  • JOHN
  • LORRAINE
  • RODNEY