beautypg.com

Trim – Metrohm tiamo 1.1 Manual User Manual

Page 84

background image

56

General program functions

Examples

SubText("Citric acid";9;5) = acidic

SubText("Citric acid";9;6) = invalid

, from the position 9 only five characters

are present

SubText('MV.ID2';1;3)

= the first three characters of the identification 2

Trim

Syntax

y = Trim(Text)

Returns the

Text

without any empty spaces in front of it or behind it.

y = Trim(Text ; Sample text)

Returns the

Text

without

Sample text

.

Parameter

Text

The parameter can either be entered directly or as a Variable of the type

Text

,

Number

or

Date/Time

.

Sample text

The parameter can either be entered directly or as a Variable of the type

Text

,

Number

or

Date/Time

. If the types of the two parameters are not identi-

cal then the type

Sample text

will always be converted to the type

Text

(see

Functions - Type conversion).

Note

Entries of the type

Number

are always given with one decimal place.

Example:

TextPosition("12345";3) = invalid

, as before the operation the 3 is con-

verted to 3.0 and this is not contained in the text.

Examples

Trim(" Citric acid ") = "Citric acid"

Trim("Citric acid";"acid") = lemons

Trim("Citric acid";"salt") = Citric acid