6 out of 14 rated this helpful - Rate this topic

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)

Remarks

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

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".

Requirements

Version 1

Reference

Left Function

Right Function

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

LTrim; RTrim; and Trim Functions

Reference

Community Additions