Parameter 1: Filter function operator Parameter 2: any text Operators of the filter functions: - "=" shows all lines that exactly match the specified filter text.
- "<>" shows all lines that do not exactly match the specified filter text.
- "contains" shows all lines that contain the specified filter text [at any position].
- "notcontains" shows all lines that do not contain the specified filter text.
Parameters can be linked with "and" and "or": =Filter1 or Filter2 The numerical filter values must be entered without apostrophes!
As of version 2.9.0.221, it is also possible to specify numerical filter values. This allows numbers to be imported that are larger or smaller than a certain value. "<Number" shows all rows with a value greater than the specified number. If the value in a row is text, it is not included. "<=Number" shows all rows with a value greater than or equal to the specified number. If the value in a row is a text, it is not taken into account. ">Number" shows all rows with a value that is less than the specified number. If the value in a row is a text, it is not taken into account. ">=Number" shows all rows with a value that is less than or equal to the specified number. If the value in a row is a text, it is not taken into account.
| Info |
|---|
Please note that the NumberDecimalSeparator for the filter criterion (here called number) is always the point. For the values, the NumberDecimalSeparator/NumberGroupSeparator depends on the Connector Settings / System Settings. |
For non-numeric filter values, the following filters can be set: "<Text" - shows all lines whose text comes after the specified filter text in their relative position in the alphabetical sort order. Example: "Root < Tooth" is true, "Root < Root" is false. "<=Text" - shows all lines whose text comes in their relative position in the alphabetical sort order at the same position or after the specified filter text. Example: "Root <= Root" is true. ">text" - shows all lines whose text comes before the specified filter text in their relative position in the alphabetical sort order. Example: "Tooth > Root is true", "Root > Root" is false. ">=text" - shows all lines whose text comes at the same position or before the specified filter text in their relative position in the alphabetical sort order. Example: "Root >= Root" is true.
Non numerical filter values must be entered with apostrophes! | 
