Trim

Description

Removes leading and trailing spaces from a string.

Syntax

Trim ( string {, removeallspaces } )

Argument

Description

string

The string you want returned with leading and trailing spaces deleted

removeallspaces

A boolean indicating that all types of spaces should be deleted


Return value

String.

Returns a copy of string with all leading and trailing spaces deleted if it succeeds and the empty string ("") if an error occurs. If string is null, Trim returns null.

Usage

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

If you do not include the optional removeallspaces argument or its value is false, only the space character (U+0020) is removed from the string.

If the removeallspaces argument is set to true, all types of space characters are removed. See LeftTrim for a list of space characters.

Examples

This statement returns BABE RUTH if all the leading and trailing spaces are space characters:

Trim(" BABE RUTH ")

This statement returns BABE RUTH if the leading and trailing spaces include other types of white space characters:

Trim(" BABE RUTH ", true )

This example removes the leading and trailing spaces from the user-entered value in the SingleLineEdit sle_emp_fname and saves the value in emp_fname:

string emp_fname
emp_fname = Trim(sle_emp_fname.Text)

See also

LeftTrim

RightTrim

Trim method for DataWindows in the section called “Trim” in DataWindow Reference.