Right Trim

The RTrim function returns a string in which blank spaces on the right side of the input string have been removed. For example, using the RTrim function on the string "MicroStrategy     " would return the string "MicroStrategy".

Syntax

RTrim(Argument)

Where:

Argument is a metric, fact, column, or string representing the text string(s).

Example

The RTrim function helps to remove trailing blank spaces, which may have been caused by errors in data entry. Removing these spaces helps standardize the display of information, as well as makes the information more readable. For example, an LU_CUSTOMER table includes an ADDRESS column. You can create an attribute form to remove any trailing blank spaces from the addresses. The definition of such an attribute form is shown below:

RTrim([ADDRESS])

Any trailing blank spaces included in the addresses are removed from the display for the attribute form.

To remove both leading and trailing blank spaces, use the Trim function.