Converts a text string to a number, where possible.

Syntax

@TextToNumber( string )

Parameters

string

Text or text list. The string you want to convert to a number. If the string contains both numbers and letters, it must begin with a number to be converted properly. For example, the string "12ABC" converts to 12, but "ABC12" produces an error.

number

Number or number list. The string, converted to a number.

If the parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.

This function is useful for converting a number in a text field to a number that can be used for computation in a number field.

You can't use @TextToNumber to convert special text (such as that returned by @DocChildren or @DocDescendants) to a number.

@TextToNumber returns an error If you try to pass anything besides a string into it.

Language cross-reference

Val function of LotusScript language

Str function of LotusScript language

CInt function of LotusScript language

CLng function of LotusScript language

CSng function of LotusScript language

CDbl function of LotusScript language

Example
See Also

Converting data types
@TextToTime
"Extending the Resource Reservations database" on the Lotus Developer Domain
@ToNumber

Glossary