Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

STRING

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

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 constant have to be escaped with a backslash (\'). A literal backslash within a STRING constant also have to be escaped with a backslash (\\).

Unicode characters are supported in all functions which support the STRING type, unless specifically noted in the documentation for the given function. Everywhere the word "character" is used, "Unicode character" can be implicitly assumed, independent on the size of the underlying encoding of the Unicode string. For example the LEN function will count the number of Unicode characters in the input STRING, and not the number of bytes in the underlying representation.

Example

[1] Create STRING constants. Note there are no escaping backslash characters present in the resulting STRING column, since backslash escaping is only relevant in STRING constants within a PQL query.

Query

Column1

' '

Column2

'Test 123'

Column3

'Test \'123\''

Column4

'Test \\123\\'

Input

Output

Result

Column1 : STRING

Column2 : STRING

Column2 : STRING

Column4 : STRING

''

'Test 123'

'Test '123''

'Test \123\'

See also: