Gebruikershulpmiddelen

Site-hulpmiddelen


nl:cachevariables

Verschillen

Dit geeft de verschillen weer tussen de geselecteerde revisie en de huidige revisie van de pagina.

Link naar deze vergelijking

Beide kanten vorige revisieVorige revisie
Volgende revisie
Vorige revisie
Volgende revisieBeide kanten volgende revisie
nl:cachevariables [2022/06/05 07:49] – Removed translation Fix Me, page is translated linstylemonnl:cachevariables [2022/10/29 09:41] – [Numeric operators] linstylemon
Regel 74: Regel 74:
 |Decimaal | Getal met decimalen | Gebruik cijfers met decimale punt of komma | ''3.14'', ''-3.14'', ''3,14''| |Decimaal | Getal met decimalen | Gebruik cijfers met decimale punt of komma | ''3.14'', ''-3.14'', ''3,14''|
 |String | Tekst | Waarde omringen met ''%%'%%'' of ''%%"%%''\\ Om de ''%%'...'%%'' of ''%%"..." te gebruiken %%'' zichzelf, typ ''%%''%%'' of ''%%""%%''| ''%%'test'%%'', ''%%"test"% %''\\ ''"Hij zei ""ja""!"''| |String | Tekst | Waarde omringen met ''%%'%%'' of ''%%"%%''\\ Om de ''%%'...'%%'' of ''%%"..." te gebruiken %%'' zichzelf, typ ''%%''%%'' of ''%%""%%''| ''%%'test'%%'', ''%%"test"% %''\\ ''"Hij zei ""ja""!"''|
 +
 ==== Numeric operators ==== ==== Numeric operators ====
  
 The following numeric operators are supported: The following numeric operators are supported:
  
-^ Operator ^ Function Example +^ Operator ^ Functie Voorbeelden 
-|''+''|Addition|''2+4'' evaluates to '' 6''+|''+''|Optellen|''2+4'' evalueert naar '' 6''
-|''-''|Subtraction\\ (or negating a number)|''6-4'' evaluates to ''2''\\ ''-(5-2)'' evaluates to ''-3''+|''-''|Aftrekken|''6-4'' evalueert naar ''2''\\ ''-(5-2)'' evalueert naar ''-3''
-|''*''|Multiplication|''3*4'' evaluates to ''12''+|''*''|Vermenigvuldigen|''3*4'' evalueert naar ''12''
-|''/''|Division|''12/3'' evaluates to ''4''+|''/''|Delen|''12/3'' evalueert naar ''4''
-|''%''|Modulo|''12%5'' evaluates to ''2''+|''%''|Modulo|''12%5'' evalueert naar ''2''
-|''^''|Potentiate|''3^3'' evaluates to ''9''+|''^''|Machtsverheffen|''3^3'' evalueert naar ''9''
-|''!''|Factorize|''4!'' evaluates to ''24''| +|''!''|Factorisatie|''4!'' evalueert naar ''24''|
- +
-==== Relational operators and conditions ==== +
- +
-Relational operators like ''<'' or ''=='' can be used to compare two values with each other. In general, such an operation will return the value ''1'' if the comparison yields true and the value ''0'' if it yields false.  +
- +
-For example, the expression ''3 < 4'' will compute to the value ''1''+
- +
-Relational operators are especially used in the ''if'' function. This function evaluates its first parameter. If this parameter is true (means: has a value > 0 or is a non-empty string) then it returns its second parameter. Else, and if it has a third parameter, the third parameter is returned. +
- +
-The ''if'' function accepts any number of parameters and interprets them in an "if-then-if-then-if-then-...-else" cascade.  +
- +
-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 ''if(A==5;50;A==4;40;30)'' will evaluate to ''50'' if ''A=5'', to ''40'' if ''A=4'' and to ''30'' for any other value of ''A''+
- +
-^ Operator ^ Meaning ^ Example ^ +
-|''==''| Checks for equality | ''2==2'' evaluates to ''1''(=true)| +
-| ''<>'' | Checks for inequality. | ''3<>2'' evaluates to ''1''(=true)| +
-|''<'' | Is less than | ''3<4'' evaluates to ''1''(=true)| +
-| ''<='' | Is less or equal than | ''3<=3'' evaluates to ''1''(=true)| +
-|''>'' | Is greater than | ''3>4'' evaluates to ''0''(=false)| +
-|''>=''| Is greater or equal than | ''5>=5'' evaluates to ''1''(=true)| +
- +
-==== 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 ''sin(90)''. An example for a two-parameter function call is ''rot('test'; 13)''+
- +
-The following functions are defined: +
- +
-^ Function ^ Synonyms ^ Description ^ Parameter 1 ^ Parameter 2 ^ Example ^ +
-|''sqrt''|-|calculates square root of given parameter|numeric parameter| - |''sqrt(9)'' evaluates to ''3''+
-|''sin''/''cos''/''tan'' |-| calculates sinus/cosinus/tangens of given parameter | numeric parameter in degree(!)| - | ''sin(90)'' evaluates to ''1''+
-|''abs''|-| calculates absolute value | numeric parameter | - | ''abs(-34)'' evaluates to ''34''+
-|''round''|-| rounds decimal values mathematically | value to round | optional: number of places to round to | ''round(4.65)'' evaluates to ''5'', ''round(4.65;1)'' evaluates to ''4.7''+
-|''if''|-| evaluates conditions and returns conditional values | list of if-then-else-values. See previous section for details | - | ''if(3<4;5;6)'' evaluates to ''5''+
-|''checksum''|''cs''| calculates checksum of given numeric value. Calculates lettervalue if given paramter is of type text | positive integer or text | - | ''checksum(345)'' evaluates to ''12''+
-|''ichecksum''|''ics''| calculates iterative checksum of given numeric value. Starts from lettervalue if given parameter is of type text | positive integer or text | - | ''ichecksum(345)'' evaluates to ''3''+
-|''lettervalue''|''lv'', ''wordvalue'', ''wv'' | calculates lettervalue of given string value | string | - | ''lettervalue('test')'' evaluates to ''64''+
-|''rot''|-| calculates rotated string of given string value | string | count to rotate by | ''rot('abc'; 1)'' evaluates to '''bcd'''+
-|''rot13''|-| calculates rotated-13 of given string value | string | - | ''rot13('abc')'' evaluates to '''nop'''+
-|''roman''|-| scans a given string value as a roman number and returns its decimal value | string | - | ''roman('VI')'' evaluates to ''6''.| +
-|''vanity''|''vanitycode'', ''vc''| returns the vanity code of a string | string | - | ''vanity('cgeo')'' evaluates to ''2436''.| +
- +
- +
-==== 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: ''Test'', ''T1'', ''t'', ''Tt123''. Examples for non-legal variable names are: ''1a'', ''2'' +
- +
-One-letter-variables can just be typed into the formula and will be evaluated along. For example, the formula ''A + 2'' is valid. If ''A'' has the value ''5'', the formula will evaluate to ''7''+
- +
-If multiple chars are concatenated within a formula, they will be interpreted as individual one-letter-variables. For example, the formula ''AA + 2'' will be interpreted as variable ''A'' concatenated two times and adding ''2'' afterwards. If ''A=4'', this formula will evaluate to ''44 + 2 = 46''. See following section for more details wrt concatenation. +
- +
-Variable names longer than one char can be declared in Unix-Bash-Style by prepending their name with ''$''. For example, a variable named ''Test'' is can be referenced using ''$Test''. The formulua ''$Test + 2'' is valid. If value for variable ''Test'' is ''4'' the formula will evaluate to ''6''.  +
- +
-In situations where variable name conflicts with following alphas/chars, the variable name can be enclosed in ''{}'' to differentiate it from following text. For example, the following expression will concatenate the value of variable ''Test'' with the value of variable ''A'': ''${Test}A'' +
-  +
-Some more complex examples: +
- +
-  * The formula ''A + $A * $Test - t'' uses three variables named ''A'', ''Test'' and ''t''. The variable ''A'' is used in two places. Assuming ''A=2'', ''Test=3'' and ''t=1'', the formula would evaluate to ''7''+
-  * The formula ''AA + b + $A1'' uses three variables ''A'', ''b'' and ''A1''. Assuming ''A=2'', ''b=3'' and ''A1=4'', the formula would evaluate to ''29'' ( = 22 + 3 + 4) +
-  * The formula ''AB(B+1)'' uses two variables ''A'' and ''B''. Assuming ''A=2'' and ''B=3'', the formula would evaluate to ''234''  +
-  * The formula ''$AB(B)(B+1)'' uses two variables ''AB'' and ''B''. Assuming ''AB=2'' and ''B=5'', the formula would evaluate to ''256''  +
-  * Using ''{}'' syntax, the previous example could also be written like this: ''${AB}B(B+1)'' +
- +
-==== 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, which can be concatenated, include e.g. integer digits, variables, expressions in parenthesis and the Overflow character (see next subsection). +
- +
-For example, the formula ''AA(A+4)55$Test(3)'' contains two variables ''A'' and ''Test''. Assuming ''A=9'' and ''Test=70'', it would evaluate to ''991355703''+
-==== Overflow character ==== +
- +
-In concatenated expressions, the character ''_'' can be used as an overflow sign. It is a placeholder for possible spillovers if numeric variables evaluate to a value with more than one digit, otherwise it is filled with 0.  +
- +
-An example should make the usage clear:+
  
-  * The Formula ''1A'' with ''A=2'' will evaluate to ''12'' 
-  * The Formula ''1_A'' with ''A=2'' will evaluate to ''102'' 
-  * The Formula ''1_A'' with ''A=23'' will evaluate to ''123'' 
-  * The Formula ''%%1__A%%'' with ''A=23'' will evaluate to ''1023'' 
-  * The Formula ''%%1__%%A'' with ''A=234'' will evaluate to ''1234'' 
  
  
nl/cachevariables.txt · Laatst gewijzigd: 2023/06/05 09:04 door linstylemon