Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference TRIMLEFT
Functions and Expressions Reference Guide
212
TRIMLEFT
The TRIMLEFT function removes leading characters from a text item.
Syntax
TRIMLEFT ( single-text-expression [ , single-text-expression
] )
Meaning
TRIMLEFT ( item_to_trim [ , text_to_trim ] )
Returns
This function returns a single-text-item.
Removes leading characters that match text_to_trim from item_to_trim and
returns the result as a single-text-item. If text_to_trim is not specified, leading
spaces are removed from item_to_trim.
Example
TRIMLEFT ( " abc" ) returns abc
TRIMLEFT ( "000345" , "0" ) returns 345
TRIMLEFT ( LastName Column:Row , "<WSP>" ) returns the content of
LastName Column after removing all leading whitespace characters: space,
horizontal tab, carriage return, or line feed characters.
Uses
Use
TRIMLEFT to remove spaces or some other text string at the beginning of
some text.
Related Functions
FILLLEFT, FILLRIGHT, LEAVEALPHA, LEAVEALPHANUM, LEAVENUM,
LEAVEPRINT, SQUEEZE, SUBSTITUTE, TRIMRIGHT