Using conditional expressions
You can use the following operators and wildcard characters to configure a conditional expression.
- If you use wildcard characters, you can only use the operators Is like and Is not like.
Available operators
Operator | Stands for |
---|---|
> | Is greater than |
≥ | Is greater than or equals |
< | Is less than |
≤ | Is less than or equals |
= | Equals |
≠ | Is different than |
≈ | Is like. This operator matches a given pattern. Use this operator if the value in the conditional expression contains a wildcard. This ensures that the wildcard is interpreted as such. With other operators, the value is interpreted literally. |
≉ | Is not like. This operator does not match the given pattern. Use this operator if the value in the conditional expression contains a wildcard. This ensures that the wildcard is interpreted as such. |
Available wildcard characters
Use wildcards in combination with the operators Is like or Is not like only. This ensures that the wildcard is interpreted as such. With other operators, the value is interpreted literally.
Character | Stands for | Example |
---|---|---|
? | Any single character | aaa is like a?a, aba is like a?a, etc. a1a is not like a?a (1 is a digit) , adda is not like a?a (? replaces only one character). |
* | Zero or more characters | aba is like a*a. For example, aba, abcda, a121a, ab1da also are like a*a. |
# | Any single digit (0-9) | a2a is like a#a, a3a is like a#a.aza is not like a#a (z is not a digit), a23a is not like a#a (# replaces only one digit). |
[<expression>] | Any character or digit | aaa is like a[abc]a, aba is like a[abc]a, etc. Other expressions: a[a-z]a, a[a-zA-Z]a, a[0-9a-z]a. |