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)