| Table of Contents |
|---|
...
To concatenate several And/or conditions, add parentheses for each condition, as in the following example: IF(('unit_is_stationary' = 'Yes')&&('unit_is_stationary' = 'Yes'); 'OK';'Not OK')
Single quotes are supported inside a value only by prefixing them with the escape string(\) i.e. a formula
can look like this: 'unit_name' + ' Te\'st' and the result will be unit name Test
...
Examples of common formulas
Expressions | Formula |
|---|---|
XX OR XX | (XX|XX) |
XX AND XX | (?=.*XX)(?=.*XX) |
Not XX OR Not XX | ^(?!.*(XX|XX)).* |
XX=the expression
Example of using the tool
...