The following is a list of operators that can be used in Expressions:
Operator | Description | Symbol |
is equal to | Is true when both sides are equal | == |
is not equal to | Is true when the two sides are not equal | != |
is greater than | Is true when the number on the left is greater than the number on the right | > |
greater or equal | Is true when the left side is greater than or equal to the left side | >= |
is less than | Is true when the left side is less than the right side | < |
less than or equal | Is true when the left side is less than or equal to the right side | <= |
in | Is true when the left side is in the range defined by the right side | in () |
is blank | Is true when the field is blank | == blank |
is not blank | Is true when the field is not blank | != blank |
matches pattern | Is true when the value on the left matches the regular expression on the right (regular expressions can be entered in “”) | ~ |
does not match pattern | Is false when the value on the left matches the regular expression on the right (regular expressions can be entered in “”) | !~ |
or | Logical “or”, is true when the left, right, or both are true | || |
and | Logical “and”, is true when the left and right are true | && |
add | Adds two numbers, concatenates two strings | + |
subtract | Subtracts the number on the right from the number on the left | - |
multiply | Multiplies the number on the left by the number on the right | * |
divide | Divides the number on the left by the number on the right | / |
modulo | Returns the remainder of the left number divided by the right number | % |