You are viewing the documentation for Blueriq 15. Documentation for other versions is available in our documentation directory.
INTEGER
Converts a value of another data type into an integer.
Syntax
INTEGER(string value, [format], [locale]) INTEGER(number value) INTEGER(currency value) INTEGER(percentage value) INTEGER(Boolean value)
Inputs
value - The value of the data type that is converted to integer.
format (optional) - The format used for conversion. Format must be enclosed by quotes, e.g. "00.00".
locale (optional) - Locale specifies a combination of language and country. A locale in the option set will override the one that is used as default in the project. Commonly used are en-US, en-GB, nl-NL, nl-BE, fr-FR. The list of language codes can be found here. A list of country codes can be found here.
Default formats
For all conversion functions that use a string as parameter, the [format] describes the format in which the input string value parameter is in. When not specifying a format, by default this format is used:
- string to integer - no default format, the complete string is parsed to integer (leading zeros are possible and will be removed).
Return type
- integer
Examples
- INTEGER(“1,0”, ”#0.0”, “nl-NL”) results in an integer value 1.