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/06/05 07:49] – [Comments] translated linstylemon | nl:cachevariables [2022/10/29 09:41] – [Numeric operators] linstylemon | ||
---|---|---|---|
Regel 1: | Regel 1: | ||
- | FIXME **Deze pagina is nog niet volledig vertaald. Help alsjeblieft de vertaling compleet te maken.**\\ // | ||
- | |||
====== Cache Variables ====== | ====== Cache Variables ====== | ||
Regel 76: | Regel 74: | ||
|Decimaal | Getal met decimalen | Gebruik cijfers met decimale punt of komma | '' | |Decimaal | Getal met decimalen | Gebruik cijfers met decimale punt of komma | '' | ||
|String | Tekst | Waarde omringen met '' | |String | Tekst | Waarde omringen met '' | ||
+ | |||
==== Numeric operators ==== | ==== Numeric operators ==== | ||
The following numeric operators are supported: | The following numeric operators are supported: | ||
- | ^ 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 '' | ||