LTrim; RTrim; and Trim Functions
Returns a copy of a string without leading spaces (LTrim), trailing
spaces (RTrim), or both leading and trailing spaces (Trim).
LTrim(string)
RTrim(string)
Trim(string)
The string argument is any valid string expression. If
string contains Null, Null
is returned.
Remarks
The following example uses the LTrim, RTrim, and Trim
functions to trim leading spaces, trailing spaces, and both leading and trailing
spaces, respectively: Dim MyVar
MyVar = LTrim(" vbscript ") ' MyVar contains "vbscript ".
MyVar = RTrim(" vbscript ") ' MyVar contains " vbscript".
MyVar = Trim(" vbscript ") ' MyVar contains "vbscript".
|