Function Character Types Class

TrimInPlace

Remove both the leading and trailing spaces from the string argument rValue and also return that value.

Signature (Visual Basic / VBA)

Public Function TrimInPlace( _
    ByRef rValue As Variant _
    ) As Variant

Code Example

    Assuming
       Dim S As String
       S = "  This is a sample.  "
    for example
       TrimInPlace(S) = "This is a sample."
    leaves
       S = "This is a sample."

Parameters

Parameter Description
rValue String argument which is to have all surrounding space characters removed. Function also returns the "trimmed" value of rValue.

Notes & Version History

Note Function only works for characters in the ANSI Windows character set because it uses the built-in Visual Basic Trim() function.