AmountValue

Syntax

AmountValue(str_amount, thousand_sep, decimal_sep);

str_amount	A string specifying the amount.
thousand_sep	A string specifying the thousand separator.
decimal_sep	A string specifying the decimal separator.

Description

Converts a string to a numerical value using a specified format.

The thousand separator is only allowed every three digits, except in the beginning or at the end of the number. There cannot be any thousand separator after the decimal separator.
For example amountvalue("1,200.65", ",", ".");
For comparison, amountvalue("1,2000.65", ",", "."); is not a valid conversion.

If you leave the separator arguments empty, the separators are not checked. For example, if you leave the thousand separator argument empty, as in amountvalue("1200.65", "", "."); the number does not need to contain a thousand separator.

The numerical value can contain a minus sign (-) both at the beginning and at the end of the value. A plus sign (+) is only allowed in the beginning.

Returns

A numeric expression.

Example

$a="1,200.65";
$b="1 765,15";
$c=amountvalue($a,",",".");
$d=amountvalue($b," ",",");

Result:

$c=1200.65
$d=1765.15