text_to_number

Use the text_to_number function to convert a text to a number.

 text_to_number ( text )

This function returns a value of type NUMBER.

The function has one parameter:

text, type TEXT. The text to be converted to a number.

The interpretation of the number (decimal point, thousands separator) depends on the currently active output language. Conversion stops are the first character that is not a digit or separator.

Examples

text_to_number ("123") results in 123

text_to_number ("123.000") results in 123

text_to_number ("123.000") results in 123000 (output language NLD)

text_to_number ("12a30") results in 12