Selecting filter options

The filter options available depend on whether the data type is numeric, time, or string.

Case insensitive

Case Insensitive specifies that upper and lowercase values for a string item are treated equally. For example, case insensitive specifies that ABC and abc are equivalent.

Comparison operator

Comparison operators compare values with your item's filter From value. You select a comparison operator from the descriptions listed in the Filter Option dialog, and the operator is automatically inserted into the data extraction query. The default setting is None.

Description Operator Mode
None Default
Display all values <ALL> Default
Is greater than > Default
Is greater than or equal to >= Default
Is less than < Default
Is less than or equal to <= Default
Is not equal to <> Default
Is Like *=% Default
Not Like *!% Default
Is in list << Combination
Is not in list <<! Default
Is Null <IS NULL> Default
Not Null <IS NOT NULL> Default


Segment extracts a sub-section from a string. It contains these details:

  • Offset: The number of characters prior to the start of the segment string.
  • Length: The number of characters in the segment string.

For example, specify Offset as 14, and Length as 1, to extract the string c from the string debit/credit: c 19/03/2012.


Mode contains these details:

  • Default: To apply pattern matching or comparison operators in the Data Filter Item criteria.
  • Combination: To filter on contiguous and non-contiguous ranges, using a combination of ranges (.. 2 dots) and filter values separated by comma ( , ) syntax. For example, specify <<10000..12000,19000,22000 to filter on account codes 10000,11000,12000,19000 and 22000.
  • Literal: To use reserved characters such as %, < and > literally in a search.