LTrim, RTrim, and Trim Functions

Description

Returns a copy of a string without leading spaces (LTrim), trailing spaces (RTrim), or both leading and trailing spaces (Trim).

Syntax

LTrim(string)

RTrim(string)

Trim(string)

The string named argument is any valid string expression. If string contains no valid data, Null is returned.

See Also

Left Function, Right Function.

Example

This example uses the LTrim and RTrim functions to strip leading and trailing spaces from a string variable. Using the Trim function alone achieves the same result.

MyString = "  <-Trim->  "       ' Initialize.
TrimString = LTrim(MyString)    ' TrimString = "<-Trim->  ".
TrimString = RTrim(MyString)    ' TrimString = "  <-Trim->".
TrimString = LTrim(RTrim(MyString))    ' TrimString = "<-Trim->".
' Using the Trim function alone achieves the same result.
TrimString = Trim(MyString)    ' TrimString = "<-Trim->".