Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
Description
LEFT returns the first n characters of a string. If the string is smaller than n characters, the whole string is returned.
Supported input column types: STRING
Output column type: STRING
NULL-values: If the value is NULL, the result is NULL
Syntax
LEFT ( table.column, n )
Example
Get first character of string.
Query
Column1
LEFT ( "Table1"."Column1" , 1)
Input
Table1
| Column1 : STRING |
|---|
| 'a ' |
| ' a' |
| '' |
| null |
| '' |
| null |
| ' ' |
| '%@#$' |
Output
Result
| Column1 : STRING |
|---|
| 'a' |
| ' ' |
| '' |
| null |
| '' |
| null |
| ' ' |
| '%' |