RightTrim

Description

Removes spaces from the end of a string.

Syntax

RightTrim ( string {, removeallspaces } )

Argument

Description

string

The string you want returned with trailing blanks deleted

removeallspaces

A boolean indicating that all types of spaces should be deleted

Returns

String. Returns a copy of string with trailing blanks deleted if it succeeds and the empty string ("") if an error occurs. If any argument’s value is null, RightTrim returns null.

Usage

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

Example 1

This statement returns RUTH if all the trailing blanks are space characters:

RightTrim("RUTH ")

Example 2

This statement returns RUTH if the trailing blanks include other types of white space characters:

RightTrim("RUTH ", true)

See also