LTrim (Left Trim)

The LTrim function returns a string in which any leading blank spaces on the left side of the input string have been removed. For example, using the LTrim function on the string " MicroStrategy" would return the string "MicroStrategy".

The LTrim function helps to remove blank spaces that may have been caused by errors in data entry. Removing these spaces helps standardize the display of information and makes the information more readable.

Syntax

LTrim(Argument)

Where:

Argument is a metric, fact, column, or string representing the text string(s).

For information on the syntax used in your specific database, see MicroStrategy and Database Support for Functions and see the section that corresponds to your database.

Example

An LU_CUSTOMER table includes an ADDRESS column. You can create an attribute form to remove any leading blank spaces from the addresses. The definition of such an attribute form is shown below:

LTrim([ADDRESS])

Any leading blank spaces included for addresses are removed from the display for the attribute form.

To remove both leading and trailing blank spaces, use the Trim function (Trim).