<<

Contents

Search

>>

 

STRVAL$

 

 

Function

 

 

Syntax:

STRVAL$(<Type>,<String>)

 

<Type>

= <NUM-EXPRESSION>

<String>

= <STRING-EXPRESSION>

 

 

Meaning:

Removes grouping separators from a string.

 

The function VAL does not consider grouping separators and only interprets the point "." as decimal point. In German speaking countries the comma "," is common as decimal separator and the point "." as grouping separator.

 

With <Type> = 1  STRVAL$ proceeds on the assumption that <String> has the German format and returns a character string in which all points are removed from <String> and all commas are replaced by points so that the function VAL can interpret the character string correctly.

 

With <Type> = 0 the country specific grouping separators (EBUS_GROUPING_SEPARATOR$) are removed and the country specific decimal separators (EBUS_DECIMAL_SEPARATOR$) are replaced by the point "."

 

If <Type> <> 1 and  <> 0, only all commas are removed from <String>.

 

Parameter:

Type

Type of conversion

String

String expression

 

Sample:

 

Ergebnis

STRVAL$(1,"123.456,78")

STRVAL$(0,"123,456.78")

STRVAL$(2,"123.456,78")

"123456.78"

"123456.78"

"123.45678"

 

See also:

VAL

STRNUM$

STRFORMAT$