Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7

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 )

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

[1] Compute string length.

Query

LEN ( "Table1"."Column1" )

Input

Column1 : STRING
'a '
' a'
''
null
' '
'Edit the data in your Data Model with the Process Query Language'
' '
'abc'

Output