Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
DEPRECATED since 4.7
Please use TO_INT instead.
Description
STR_TO_INT converts the input strings to integers. If the input is not a number (or outside of the
supported range), null is returned. A decimal point is allowed in input, but decimal places are ignored/truncated.
Supported input column types: STRING.
Use of scientific E notation in input is not supported in STR_TO_INT and will be mapped to NULL.
Output column type: INT
Syntax
STR_TO_INT ( table.column )
NULL handling
If the value is NULL, the result is NULL as well.
Example
[1] Convert strings to integers. The numbers 9223372036854775908 and -9223372036854775809 are outside of the supported range.
Query
Column1
STR_TO_INT ( "Table1"."Column1" )
Input
Table1
| Column1 : STRING |
|---|
| null |
| '' |
| '123456' |
| '-123456.11' |
| '123456.11' |
| '123456.99' |
| '12345699' |
| '4.70E+2' |
| '-5.93E-2' |
| '9223372036854775807' |
| '-9223372036854775808' |
| '9223372036854775908' |
| '-9223372036854775809' |
Output
Result
| Column1 : INT |
|---|
null |
null |
123456 |
-123456 |
123456 |
123456 |
12345699 |
null |
null |
9223372036854775807 |
-9223372036854775808 |
null |
null |