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"

Browser not supported