Dit geeft de verschillen weer tussen de geselecteerde revisie en de huidige revisie van de pagina.
Beide kanten vorige revisieVorige revisieVolgende revisie | Vorige revisieVolgende revisieBeide kanten volgende revisie | ||
nl:cachevariables [2022/10/29 09:28] – [Waardetypes] linstylemon | nl:cachevariables [2022/10/29 09:42] – [Numeric operators] linstylemon | ||
---|---|---|---|
Regel 75: | Regel 75: | ||
|String | Tekst | Waarde omringen met '' | |String | Tekst | Waarde omringen met '' | ||
- | ==== Numeric operators | + | ==== Numerieke operatoren |
- | The following numeric operators are supported: | + | De volgende Numerieke operatoren worden ondersteund: |
- | ^ Operator ^ Function | + | ^ Operator ^ Functie |
- | |'' | + | |'' |
- | |'' | + | |'' |
- | |'' | + | |'' |
- | |''/'' | + | |''/'' |
- | |'' | + | |'' |
- | |'' | + | |'' |
- | |'' | + | |'' |
- | ==== Relational operators and conditions ==== | ||
- | |||
- | Relational operators like ''<'' | ||
- | |||
- | For example, the expression '' | ||
- | |||
- | Relational operators are especially used in the '' | ||
- | |||
- | The '' | ||
- | |||
- | This means, that if the function was given 5 parameters then: | ||
- | * If the first parameter is true, then the second is returned | ||
- | * Else if the third parameter is true, then the fourth parameter is returned | ||
- | * Else the fifth parameter is returned | ||
- | |||
- | For example '' | ||
- | |||
- | ^ Operator ^ Meaning ^ Example ^ | ||
- | |'' | ||
- | | ''<>'' | ||
- | |''<'' | ||
- | | ''< | ||
- | |''>'' | ||
- | |''> | ||
- | |||
- | ==== Functions ==== | ||
- | |||
- | Functions all start with a letter, contain only letters and digits and have a directly attached parameter list in parenthesis. Multiple parameters are separated using '';'' | ||
- | |||
- | An example for a one-parameter function call is '' | ||
- | |||
- | The following functions are defined: | ||
- | |||
- | ^ Function ^ Synonyms ^ Description ^ Parameter 1 ^ Parameter 2 ^ Example ^ | ||
- | |'' | ||
- | |'' | ||
- | |'' | ||
- | |'' | ||
- | |'' | ||
- | |'' | ||
- | |'' | ||
- | |'' | ||
- | |'' | ||
- | |'' | ||
- | |'' | ||
- | |'' | ||
- | |||
- | |||
- | ==== Variables ==== | ||
- | |||
- | Variables are used in a formula as placeholders for values. When a formula containing a variable is evaluated, it needs to be passed a value for each of the contained variables in order to be correctly evaluated. | ||
- | |||
- | Variable names are case sensitive and have to start with an alphanumeric char. Remaining chars can be alphanumeric or digits. | ||
- | Examples for legal variable names are: '' | ||
- | |||
- | One-letter-variables can just be typed into the formula and will be evaluated along. For example, the formula '' | ||
- | |||
- | If multiple chars are concatenated within a formula, they will be interpreted as individual one-letter-variables. For example, the formula '' | ||
- | |||
- | Variable names longer than one char can be declared in Unix-Bash-Style by prepending their name with '' | ||
- | |||
- | In situations where variable name conflicts with following alphas/ | ||
- | |||
- | Some more complex examples: | ||
- | |||
- | * The formula '' | ||
- | * The formula '' | ||
- | * The formula '' | ||
- | * The formula '' | ||
- | * Using '' | ||
- | |||
- | ==== Concatenations ==== | ||
- | |||
- | If multiple expressions are concatenated directly after another with no separating operator, values are concatenated to a consecutive expression. This expression evaluates to a number if it forms a valid numeric expression, otherwise it evaluates to a text value. | ||
- | |||
- | Expressions, | ||
- | |||
- | For example, the formula '' | ||
- | ==== Overflow character ==== | ||
- | |||
- | In concatenated expressions, | ||
- | |||
- | An example should make the usage clear: | ||
- | |||
- | * The Formula '' | ||
- | * The Formula '' | ||
- | * The Formula '' | ||
- | * The Formula '' | ||
- | * The Formula '' | ||