The toint() function

Usage

TOINT(string or float)

Parameters

Parameter	Type	Description
string or float (required)	string or float	The value to be converted to an integer.

Returns

The integer value that corresponds to the input parameter. 0 if the input is a string that starts with a non-numeric character. The integer part of the input if the input is a float. NULL if the input is NULL.

Remarks

For string input parameters that start with a numeric character, but mix numbers and letters, characters following the final number in a contiguous series of numbers will be ignored.

toIntSample.fls.xml

...
<textview id="mixedString1"
  label="Input parameter 1"
  text="ggg5343"/>
<textview label="toint() returns 0
                for strings that start with
                non-numeric characters"
  text='{TOSTRING(TOINT(mixedString1.text))}'/>
<textview id="mixedString2"
  label="Input parameter 2"
  text="5343ggg65"/>
<textview label="Characters after
                the first contiguous set of numbers
                are ignored"
  text='{TOSTRING(TOINT(mixedString2.text))}'/>
<textview id="mixedString3"
  label="Input parameter 3"
  text="5343.65ggg18.3"/>
<textview label="For floats,
                the largest integer
                less than the input is returned"
  text='{TOSTRING(TOINT(mixedString3.text))}'/>
...

Figure 276. The toint() function ignores any input after the first letter in an input string

Sample

toIntSample.fls.xml

...
<textbox id="string"
  label="Enter something you want to see as a number"
  text=""/>
<textview label="Is this the output you expected?"
  text='{TOSTRING(TOINT(string.text))}'/>
<numberbox id="number"
  label="Enter a floating point number"
  numberFormat='{decimalSeparator: ".",
                maxFraction:3}'
  float="true"/>
<textview label="This is what toint() gives you"
  text='{TOSTRING(TOINT(number.number))}'/>

Figure 277. The toint() function can handle string-type numeric values and floats

Developer Documentation

Data-binding Reference