Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

String modification

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

Description

There are multiple string functions available in Celonis that allow to modify STRING data of columns and constants.

STRINGs can be combined with other inputs (including STRING , INT and FLOAT data) using CONCAT.
Cropping STRINGs can be achieved with SUBSTRING , LEFT, RIGHT, LTRIM, and RTRIM.
The length of STRINGs can be counted with LEN.
STRINGs can be transformed using LOWER, UPPER, and REVERSE.
STR_TO_INT allows to change STRING data types to INT.

Was this helpful?

Would you like to provide feedback? Just click here to suggest edits.