Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

STRING

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

Description

The STRING type allows to handle sequences of characters, typically text. There are various String Functions available for processing STRING input.

When entering STRING constants manually, they have to be quoted with single quotes ('...'). Single quotes within a STRING have to be escaped with a backslash (\).

Example

[1] Create three STRING constants:

Query

Column1

' '

Column2

'Test 123'

Column3

'Test \'123\''

Input

Output

Result

Column1 : STRING

Column2 : STRING

Column3 : STRING

''

'Test 123'

'Test '123''

See also: