LTRIM
- Charles Bishop (Deactivated)
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 is wonderful" | "Datameer 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 " ) returns |
|---|---|
| " Datameer 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 is wonderful" | " Datameer 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 is wonderful" | " wonderful" |