Trim

Description

Removes leading and trailing spaces from a string.

Syntax

Trim ( string )

Argument

Description

string

The string you want returned with leading and trailing spaces deleted

Returns

String. Returns a copy of string with all leading and trailing spaces deleted if it succeeds and the empty string (“”) if an error occurs.

Usage

Trim is useful for removing spaces that a user might have typed before or after newly entered data.

Examples

Example 1

This expression returns BABE RUTH:

Trim(" BABE RUTH ")

See also