Syntax

Trim[$](string)

LTrim[$](string)

RTrim[$](string)

Description

Functions return the following.

Function

Returns

Trim

Copy of the passed string expression (string) with both the leading and trailing spaces removed.

LTrim

String with the leading spaces removed,

RTrim

String with the trailing spaces removed.

Trim$, LTrim$, and RTrim$

String

Trim, LTrim, and RTrim

String variant.

Null is returned if string is Null.

Comments

Trim$ returns a String, whereas Trim returns a String variant.

Null is returned if text is Null.

Example 1

'This first example uses the Trim$ function to extract the

'nonblank part of a string and display it.

Const crlf = Chr$(13) + Chr$(10)

Sub Main()

    text$ = " This is text "

    tr$ = Trim$(text$)

    MsgBox "Original =>" & text$ & "<=" & crlf & _

    "Trimmed =>" & tr$ & "<="

End Sub

Example 2

'This second example displays a right-justified string and its

'LTrim result.

Const crlf = Chr$(13) + Chr$(10)

Sub Main()

    a$ = " <= This is a right-justified string"

    b$ = LTrim$(a$)

    MsgBox a$ & crlf & b$

End Sub

Example 3

'This third example displays a left-justified string and its

'RTrim result.

Const crlf = Chr$(13) + Chr$(10)

Sub Main()

    a$ = "This is a left-justified string. "

    b$ = RTrim$(a$)

    MsgBox a$ & "<=" & crlf & b$ & "<="

End Sub

See Also

LTrim, LTrim$ (functions); RTrim, RTrim$ (functions).

T