Trim Function

Returns a FixStr (String) containing a copy of a specified string without leading and trailing spaces.

Syntax

Trim(string)

Remarks

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

The Trim$ form returns String values. The Trim form returns FixStr values.

Example

This example uses the LTrim function to strip leading spaces and the RTrim function to strip trailing spaces from a string variable. It uses the Trim function to strip both types of spaces.

Dim MyString, TrimString
MyString = " <-Trim-> " ' Initialize string. 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->".

 

See Also

Left Function, Right Function