The ToNumber()
converts a value to a number.
Syntax
ToNumber(text)
ToNumber(date, unit)
Returns
The number converted from text
or a unit from date
. If text
is not a number then this function returns “unknown”.
Parameters
text
– a text containing a number.date
– a date.unit
– the unit that is retreived fromdate
.
Note: this function uses the language setting of a portal when converting text.
Examples
ToNumber("1.34") /* 1.34 */
ToNumber("1,340") /* 1340 */
ToNumber("2000") /* 2000 */
ToNumber("") /* unknown */