Selecting and Retrieving Reports › Using Sorting and Filtering › Selection List Filtering › Special Filtering Characters

Special Filtering Characters

For character fields, three special filtering characters are provided as pattern matching characters. All other characters reference a match of that specific character. These special filtering characters are:

*

Matches any string of characters

This character is a fuzzy match character. * can reference any number of characters as well as no characters.

For example:

* Matches everything

A* Matches data starting with A

*A Matches data ending with A (A, LA, FLORIDA, and so on)

*A* Matches A anywhere in the data (A, LA, OHARE, MAINE, and so on)

?

Matches any single character including a blank. If you are looking for an actual ?, you will match all characters, not just the ?

^

Matches a single non-blank character. If you are looking for an actual ^, you will match all non-blank characters, not just the ^.

For numeric fields, six special filtering characters are provided in addition to a number specification. These special filtering characters are:

*

All values

K

Specifies the number in thousands (1,000 times the number)

M

Specifies the number in millions, (1,000,000 times the number)

:

Separates two numbers to indicate a range of numbers

+

Suffixes the number to indicate all values greater than or equal to the number

-

Suffixes the number to indicate all values less than or equal to the number