LTrim - Left Trim in Informatica

The LTRIM function removes blanks or characters from the beginning of a string.
It is available in the Express Transformation.

General Syntax
LTRIM (string [, trim_set])


LTRIM (string) removes the leading spaces or blanks from the string. When LTRIM
function is used with a trim set, which is optional, it removes the characters in the
trim set from the string.

Example : To Remove Leading Spaces
LTRIM(Student_Name)


Example : To Remove Leading Zeros
LTRIM(AGE,'0')


LTRIM Function Can Be Nested to Remove Multiple Characters

Example: The Below example removes leading blank spaces and hyphen characters.
LTRIM(LTRIM(AGE,'0'),'-')