Applies to:  CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 


Description

RTRIM returns the string with trailing whitespace removed.

Supported input column types: STRING

Output column type: STRING

NULL-values: If the value is NULL, the result is NULL

Syntax

RTRIM ( table.column )

Example


Remove trailing whitespace from strings.


Query
Column1
RTRIM ( "Table1"."Column1" )
Input
Table1
Column1 : STRING
' a'
' '
''
null
' '
' w Q f xJd5pkTPd4bjoBwYc4q0P4 '
'JeCouStHuBERtFustyPOLoris'
' %@#$%^&*()_+ '
Output
Result
Column1 : STRING
' a'
''
''
null
''
' w Q f xJd5pkTPd4bjoBwYc4q0P4'
'JeCouStHuBERtFustyPOLoris'
' %@#$%^&*()_+'


  • No labels