3 texttonumber, 4 texttotime, Texttonumber – Metrohm tiamo 2.2 (ProcessLab) User Manual
Page 89: Texttotime
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
tiamo 2.2 (ProcessLab)
■■■■■■■■
73
2.4.4.7.3
TextToNumber
Dialog window: Formula editor
▶ Operators/Functions
Syntax
y = TextToNumber(Text)
Gives 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.DurchschnTemp') = Value of the variables (Avera-
geTemp) as Number
TextToNumber('MV.ID1') = entered text of ID 1 as Number
2.4.4.7.4
TextToTime
Dialog window: Formula editor
▶ Operators/Functions
Syntax
y = TextToTime(Text;Format)
Gives 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 = inva-
lid). As a delimiter betwen Year, Month etc. you can use the following
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 parameter
must be marked by inverted commas and can comprise the following code
characters:
Characters
Significance
y
Year