Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
Description
RIGHT returns the last 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
RIGHT ( table.column, n )
Example
Get last character of string.
Query
Column1
RIGHT ( "Table1"."Column1" , 1)