Metrohm tiamo 2.1 (ProcessLab) - Manual (Page 91)

￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭ 2 General program functions
tiamo 2.1 (ProcessLab) ￭￭￭￭￭￭￭￭ 75
Parameters
Text
The parameter can be indicated either directly or as a variable of the type
Text, Number or Date/Time.
Sample text
The parameter can be indicated either directly or as a variable of the type
Text, Number or Date/Time. If the types of the two parameters do not
coincide, the type is converted from Sample text to the type Text.
Note
Entries of the type Number are always provided with a decimal place.
Example: Trim("12345";3) = 12345, as the 3 is converted to 3.0 before
the operation and this is not included in the text.
Examples
Trim(" Citric acid ") = "Citric acid"
Trim("Citric acid";"acid") = Lemons
Trim("Citric acid";"salt") = Citric acid
2.4.4.9 Miscellaneous functions
2.4.4.9.1 Case
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Case(Condition ; value_true ; value_false)
y = Case(Condition ; value_true ; value_false ; value_error)
Gives value_true if the condition is true. Otherwise value_false is given.
If an error occurs in the condition (result invalid), value_error is given.
Parameters
Condition
Number
Any variable (type Number) can be entered here, or a relational or logic
operation can be performed whose operators can be transferred either
directly or as a variable. These can be of the type Text, Number or Date/
Time.
Value_true
If condition <> 0, this parameter is saved as a result of the function. This
parameter can be transferred either directly or as a variable and can be of