Applies to:  CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 


Description

REVERSE returns the reversed string.

Supported input column types: STRING

Output column type: STRING

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

Syntax

REVERSE ( table.column ) 

Example


Reverse Strings.


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


  • No labels