Metrohm tiamo 1.0 Manual User Manual
Page 71
Formula editor
47
Parameter
Text
The parameter must only contain numerical characters or Variables of the
type
Text
as otherwise type conversion is not possible. The result of this
conversion or calculation would be "
invalid
". The text must also be enclosed
by Inverted commas.
Examples
TextToNumber("-55.3") = -55.3
TextToNumber('CV.MeanTemp')
=
value of the Common variable as a
Number
TextToNumber('MV.ID1')
= entered text of
ID 1
as a
Number
TextToTime
Syntax
y = TextToTime(Text;Format)
Returns the entered text as
Date/Time
.
Parameter
Text
The parameter must only contain numerical characters or Variables of the
type
Text
as otherwise type conversion is not possible (result = "
invalid
").
You can use the following characters as Separators between year, month,
etc.: slash (
/
), full stop (
.
), minus (-), semicolon (
;
), colon (
:
), empty space
and comma. You can determine the Sequence of the individual entries
yourself, but these must be entered in the parameter
Format
.
Format
Defines in which format or sequence the text must be entered. This pa-
rameter must be enclosed with Inverted commas and can be composed
of the following code characters:
Character
Meaning
y
Year
M
Month
d
Day
H
Hour 0...23
h
Stunde AM/PM
m
Minute
s
Second
a
AM/PM marking
Note
If you enter the time in the format
AM/PM then in addition to the formatting cha-
racter
h you must us the AM/PM marking a (see first example below).