Selecting a filter option
Case insensitive
Case Insensitive specifies that upper and lower case 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 |
|---|---|
|
None. |
|
|
Display all values. |
<ALL> |
|
Is greater than. |
> |
|
Is greater than or equal to. |
>= |
|
Is less than. |
< |
|
Is less than or equal to. |
<= |
|
Is not equal to. |
<> |
|
Is Like. |
*=% |
|
Not Like. |
*!% |
|
Is Null. |
<IS NULL> |
|
Not Null. |
<IS NOT NULL> |
Segment
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
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.