Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
Description
SUBSTRING
returns the substring of size len starting at character with index start.
Substring uses zero-based indexing, i.e., the first character is at start=0. If the requested character range is (partially) outside of the string, only the overlapping part is returned.
Supported input column types: STRING
Output column type: STRING
NULL-values: If the value is NULL, the result is NULL
Syntax
SUBSTRING ( <table.column>, start, size )
Examples
Return substring of size 1 at position 0 (the first addressable position).
Query
Column1
SUBSTRING ("Table1"."Column1", 0, 1)
Return substring of size 1 at position 1 (the second addressable position).
Query
Column1
SUBSTRING ("Table1"."Column1", 1, 1)
Return substring of size 2 at position 3 (the fourth addressable position). As the string ends after position 3,
the returned string is of size 1.
Query
Column1
SUBSTRING ("Table1"."Column1", 3, 2)