Applies to:  CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 


Description

LTRIM returns the string with leading whitespace removed.

Supported input column types: STRING

Output column type: STRING

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

Syntax

LTRIM ( table.column )

Example


Remove leading whitespace from strings.


Query
Column1
LTRIM ( "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