Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

LEN

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 )
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

Column1

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