LTRIM
Syntax
LTRIM(<string>;...)
Description
Removes leading whitespaces or other characters from text. This function is case sensitive.
Examples
In this example, LTRIMÂ has removed the leading white spaces from the specified column.Â
Column1 | LTRIM(#Column1) returns |
---|---|
"Â Â Â Â Â Datameer X is wonderful" | "Datameer X is wonderful" |
In this example, LTRIMÂ has additional added character values to remove from the leading string. LTRIMÂ searches for both the character values "Datameer" and the blank space value " ".
Column1 | LTRIM(#Column1;"Datameer X " ) returns |
---|---|
"Â Â Â Â Â Datameer X is wonderful" | "is wonderful" |
In this example, LTRIMÂ has additional added character values to remove from the leading string. LTRIMÂ searches only for the character values "Datameer". As the blank spaces are not specified and the values "Datameer" aren't leading from the string, no characters are removed.
Column1 | LTRIM(#Column1;"wonderful" ) returns |
---|---|
"Â Â Â Â Â Datameer X is wonderful" | "Â Â Â Â Â Datameer X is wonderful" |
In this example, LTRIMÂ has additional added character values to remove from the leading string. LTRIMÂ searches for the character values "sironemaDt" and the blank space value " ". The blank spaces as well as the leading values are identified and removed. The order of the values added in the formula is not taken into account.
Column1 | LTRIM(#Column1;" sironfulemaDt" ) returns |
---|---|
"Â Â Â Â Â Datameer X is wonderful" | "Â wonderful" |