Skip to main content

Celonis Product Documentation

LEN
Description

LEN returns the size of the string, i.e., the number of characters.

Supported input column types: STRING

Output column type: INT

Syntax
 LEN ( table.column )
NULL handling

If the input value is NULL, the result is NULL as well.

Example

[1]

Compute string length.

Query

Column1

         LEN ( "Table1"."Column1" )
        

Input

Output

Table1

Column1 : string

'a '

' a'

''

null

' '

'Edit the data in your Data Model with the Process Query Language'

' '

'abc'

Result

Column1 : int

2

2

0

null

1

64

1

3