Skip to main content

Celonis Product Documentation

STR_TO_INT
Deprecated

Warning

Please use TO_INT or TO_FLOAT 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

Output

Table1

Column1 : string

null

''

'123456'

'-123456.11'

'123456.11'

'123456.99'

'12345699'

'4.70E+2'

'-5.93E-2'

'9223372036854775807'

'-9223372036854775808'

'9223372036854775908'

'-9223372036854775809'

Result

Column1 : int

null

null

123456

-123456

123456

123456

12345699

null

null

9223372036854775807

-9223372036854775808

null

null

See also: