Fonctions
Functions allow obtaining values through the transformation of others. The following is a list of functions divided into categories, according to their typical use.
Mathematical functions
| Function | Comments |
|---|---|
| CelsiusToFahrenheit | Converts a temperature in degrees Celsius to degrees Fahrenheit. |
| FahrenheitToCelsius | Converts a temperature in degrees Fahrenheit to degrees Celsius. |
| Max | Returns the maximum value among a series of values. |
| Min | Returns the minimum value among a series of values. |
| Power | Returns the result of raising a given number to a given power. |
| Round | Rounds a number to the specified number of decimal places. |
| Sqrt | Calculates the square root of a number. |
| Trunc | Truncates a number, removing the fractional part. |
String handling functions
| Function | Comments |
|---|---|
| LowerCase | Converts all characters in a string to lowercase. |
| StringClean | Cleans a string by removing all unwanted characters. |
| StringPart | Returns a part of a string that contains sub-strings. |
| UpperCase | Converts all characters in a string to uppercase. |
Interpolation functions
| Function | Comments |
|---|---|
| LinearInterpolation | Performs a linear interpolation between a series of given points. |
JSON handling functions
| Function | Comments |
|---|---|
| JsonField | Gets the value of a field within a text expressed in JSON format. |
Other functions
| Function | Comments |
|---|---|
| Error | Generates an error condition containing the specified message. |
| HexToNumber | Converts a number in hexadecimal format (string) to a number. |
| If | Returns a value, between two given values, based on a condition. |
| ToBoolean | Converts a value of any type to boolean. |
| ToNumber | Converts a value of any type to numeric. |
| ToString | Converts a value of any type to string. |
Opérateurs relationnels
Les opérateurs relationnels s'appliquent dans les opérations de comparaison, et le résultat de leur application est toujours une valeur booléenne (vrai / faux).
Fonctions mathématiques
Fonctions mathématiques disponibles dans le moteur d'expressions, incluant la conversion de température, min/max, puissance, arrondi, racine carrée et troncature.