Metrohm tiamo 2.3 Patch 1 - Manual (Page 98)

2.4 Formula editor ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
82 ￭￭￭￭￭￭￭￭ tiamo 2.3 Patch 1
2.4.4.7.3 TextToNumber
Dialogfenster: Formula editor ▶ Operators/Functions
Syntax
y = TextToNumber(Text)
Returns the entered text as a number.
Parameters
Text
The parameter may only contain numerical characters or variables of
the type Text, as otherwise a type conversion is not possible. The result of
this conversion or the calculation would then be invalid. In addition, text
must be marked by inverted commas.
Examples
TextToNumber("-55.3") = -55.3
TextToNumber('CV.AverageTemp') = Value of the variables (Average-
Temp) as Number
TextToNumber('MV.ID1') = entered text of ID 1 as Number
2.4.4.7.4 TextToTime
Dialogfenster: Formula editor ▶ Operators/Functions
Syntax
y = TextToTime(Text;Format)
Returns the entered text as a Date/Time.
Parameters
Text
The parameter may only contain numerical characters or variables of
the type Text, as otherwise a type conversion is not possible (Result =
invalid). As separator between Year, Month etc. you can use the follow-
ing characters: slash (/), full stop (.), minus (-), semi-colon (;), colon (:),
space and comma. You can determine the order of the individual data
yourself, but must indicate this in the Format parameter.
Format
Indicates in which format or order the text has been entered. This para-
meter must be marked by inverted commas and can comprise the fol-
lowing code characters:
Characters Significance
y Year