3 texttonumber, 4 texttotime, Texttonumber – Metrohm viva 1.1 User Manual

Page 79: Texttotime

Advertising
background image

■■■■■■■■■■■■■■■■■■■■■■

2 General program functions

viva 1.1

■■■■■■■■

67

2.3.4.7.3

TextToNumber

Dialog window: 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 Text type, 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 quotation marks.

Examples
TextToNumber("–55.3") = –55.3

TextToNumber('CV.AverageTemp') = Value of the variables (Average-
Temp) as Number

TextToNumber('SD.ID1') = entered text of ID 1 as Number

2.3.4.7.4

TextToTime

Dialog window: Formula editor

Operators/Functions

Syntax
y = TextToTime(Text;Format)

Returns the entered text as Date/Time.

Parameters
Text

The parameter may only contain numerical characters or variables of
the Text type, as otherwise a type conversion is not possible (Result =
invalid). You can use the following characters as the separator between
year, month, etc.: slash (/), period (.), minus (-), semicolon (;), colon (:),
space and comma. You can determine the sequence of the individual
data yourself, but you must specify this in the Format parameter.

Format

Indicates in which format or order the text has been entered. This para-
meter must be highlighted by quotation marks and can comprise the
following code characters:

Characters

Meaning

y

Year

Advertising