Converts a text string to a number, where possible.

Syntax

@TextToNumber( string )

Parameters

string

Text. 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. The string, converted to a number.

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