IBM Lotus Domino Designer 8.5
  Versions 8.5 and 8.5.1

@TextToNumber

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.

Return value

number

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

Usage

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

See examples

---

Library | Support | Terms of use |

Last updated: Monday, October 5, 2009