Syntax

RTRIM(<string>;...)

Description

Removes trailing whitespaces or other characters from text. The function is case sensitive.

Examples

In this example, RTRIM has removed the trailing white spaces from the specified column.

Column1	RTRIM(#Column1) returns
"Datameer X is wonderful "	"Datameer X is wonderful"

In this example, RTRIM has additional added character values to remove from the trailing string. RTRIM searches for both the values "wonderful" and the blank space value " ".

Column1	RTRIM(#Column1;"wonderful " ) returns
"Datameer X is wonderful "	"Datameer X is"

In this example, RTRIM has additional added character values to remove from the trailing string. RTRIM searches only for the values "wonderful". As the blank spaces are not specified and the values "wonderful" are not trailing from the string, no characters are removed.

Column1	RTRIM(#Column1;"wonderful" ) returns
"Datameer X is wonderful "	"Datameer X is wonderful "

In this example, RTRIM has additional added character values to remove from the trailing string. RTRIM searches for the values "swoinrdelfu" and the blank space value " ". The blank spaces as well as the trailing values are identified and removed. The order of the values added in the formula is not taken into account.

Column1	RTRIM(#Column1;" swoinrdelfu" ) returns
"Datameer X is wonderful "	" Datam"

Browser not supported