Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
The following apply to special values of size and start:
Description
SUBSTRING
returns the substring of size size starting at character with
zero-based 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
Syntax
SUBSTRING ( table.column, start, size )
- size is negative: An error will be returned.
- size is zero: An empty STRING will be returned for all input, except NULL.
- start is negative:
- If the sum of start and size is zero or negative, an empty STRING will be returned for all input, except NULL.
- If the sum is positive, then start + size characters will be returned, starting from index zero of the input. If the input is NULL, NULL will be returned.
NULL handling
If the value is NULL, the result is NULL as well.