Filter expressions

This table shows the available filtering expressions.
Not part of the regular expressions
! Exclusion operator With an exclamation mark before the tilde, an exclusion is defined.

Example: !~^A matches all list elements which do not begin with the letter ’A’.

~ Introduction operator Introduces a regular expression in the text filter. It is not a part of the regular expression. All characters following the tilde are treated as regular expressions. To point out the importance of the tilde for the regular expression, it is placed before each regular expression.
Part of the regular expressions
^ Match-beginning-of-line -Operator Matches the beginning of a list element.

Example: ~^A matches all list elements which begin with the letter ’A’ like ’Alcoholic’, ’Apples’ or ’Australia’ but not ’Non alcoholic’.

$ Match-end-of-line-Operator Matches the end of a list element.

Example: ~.+er$ matches all list elements which end with ’er’ like ’Beer’, ’Water’ but not ’German’.

+ Match-one-or-more-Operator This is one of the repetition operators. It always refers to the shortest preceding regular expression. This can be a single character.

Example: ~c.+r$ matches all list elements which end with the letter ’r’ and have the letter ’c’ somewhere before it. For example, in the Product dimension of the Best Practices Templates database supplied with Application Studio, the string returns C2001 Citycruiser and C3000 Loader.

| Alternation Operator Matches a selection of list elements.

With the |-Operator, the OR operator [Alternation Operator], a selection can be made.

Example: ~^A|^B matches all list elements beginning with the letter ’A’ or with the letter ’B’.

(...) Grouping Operators The (...) operators group a regular expression to a unit.

Examples: ~^(..)+$ matches all list elements with an even number of characters. Here .. matches any two subsequent characters. The grouping (..) includes them; the repetition operator (+) ensures that this group exists at least once. As described above, the repetition operator refers to the smallest preceding regular expression. The even number of characters must be placed between the ^ and $. This is important because the regex ~(..)+ would match all list elements that contain at least two characters.

. Match-any-character-Operator

Example: ~^c..d matches all list elements which begin with the letter ’c’ which have the letter ’d’ exactly two places after the ’c’, as in the words ’Cheddar’ or ’Candy’.

\ Backslash-Escape-Operator If you want to look for an 'operator character' in a list element, the backslash indicates that the following character belongs to a list element and is not an operator.

Examples:

  • ~\+ matches all list elements which contain a "+" character.
  • ~\\ matches all list elements which contain a "\" character.
Note:  Regular expressions in client lists are case-insensitive and cannot be made case-sensitive. In this, they differ from .NET regular expressions in server lists.