How do I use wildcards in a report object?

Certain fields in report objects can accept wildcards and can be identified by the "Wildcards Allowed" link to the right of the field. Wildcards allow special characters to be used to match one or many unknown characters within a string.

The following wildcards can be used with your data extract:

Wildcards
Symbols Meaning
* % Match 0-n characters
? _ Match exactly 1 character

Wildcard Examples
Expression Meaning Sample Results
45* Look for all occurrences of the current field beginning with "45" 45, 4500, 4515410
99???99 Look for all 7 digit occurrences of the current field beginning with "99" and ending with "99" 9900099, 9954599