RTrim() returns the input string trimmed of any trailing spaces.
Syntax:
RTrim(text)
Return data type: string
| Argument | Description |
|---|---|
| text | The string to evaluate. |
| Example | Result |
|---|---|
| RTrim( ' abc' ) | Returns abc |
| RTrim( 'abc ' ) | Returns abc |
Example - RTrim fundamentals
Overview
Open the Data load editor and add the load script below to a new section.
The load script contains:
-
A dataset which is loaded into a data table called Example.
-
One field in the data table called InputText.
Load script
Set verbatim=1;
Example:
Load * inline [
InputText
' abc '
' def '];Results
Load the data and open a sheet. Create a new table and add this field as a dimension:
-
InputText
Create the following calculated dimension:
-
=RTrim(InputText) to remove trailing spaces from InputText.
| InputText | RTrim(InputText) |
|---|---|
| ' abc ' | ' abc' |
| ' def ' | ' def' |
The output of the RTrim function removed all trailing spaces to the right of the original text but retained all leading spaces.
Example - RTrim scenario
Overview
A customer relationship management (CRM) system contains records with inconsistent data entry that include extra trailing spaces. For reporting purposes, the data requires cleaning to remove these spaces and to ensure proper sorting and grouping of customer names.
Open the Data load editor and add the load script below to a new section.
The load script contains:
-
A dataset which is loaded into a data table called Example.
-
One field in the data table called CustomerName.
Load script
Set verbatim=1;
Example:
Load * inline [
CustomerName
'John Doe '
'Jane Smith'
'Michael Johnson '
'Emily Davis'
];Results
Load the data and open a sheet. Create a new table and add this field as a dimension:
-
CustomerName
Create the following calculated dimension:
-
=RTrim(CustomerName) to remove any trailing spaces from CustomerName.
| CustomerName | RTrim(CustomerName) |
|---|---|
| 'Emily Davis' | 'Emily Davis' |
| 'Jane Smith' | 'Jane Smith' |
| 'John Doe ' | 'John Doe' |
| 'Michael Johnson ' | 'Michael Johnson' |
The output shows that the RTrim function removed all trailing spaces from the original string values in CustomerName.
Example - RTrim advanced scenario
Overview
This example removes all trailing spaces from the original text string. The chart expression includes measures that use the Len function to count the characters in the string before and after using the RTrim function.
Open the Data load editor and add the load script below to a new section.
The load script contains:
-
A dataset which is loaded into a data table called Example.
-
One field in the data table called String.
Load script
Set verbatim=1;
Example:
Load * inline [
String
' abc '
' def '];Results
Load the data and open a sheet. Create a new table and add this field as a dimension:
-
String
Create the following calculated dimension:
-
=RTrim(String), to remove any extra trailing spaces.
Create the following measures:
-
=Len(String), to count the length of the original string.
-
=Len(RTrim(String)), to count the length of the string after the trailing spaces have been removed.
| String | RTrim(String) | Len(String) | Len(RTrim(String)) |
|---|---|---|---|
| ' abc ' | ' abc' | 10 | 6 |
| ' def ' | ' def' | 6 | 4 |
When you compare the output of the RTrim function to the original string values in the script, you can see how all trailing spaces have been removed.
The following code shows how to use the function in a load script.
Set verbatim=1;
Example:
Load *, len(RtrimString) as RtrimStringLength;
Load *, rtrim(String) as RtrimString;
Load *, len(String) as StringLength;
Load * Inline [
String
' abc '
' def '];| String | StringLength | RtrimString | RtrimStringLength |
|---|---|---|---|
| ' abc ' | 10 | ' abc' | 6 |
| ' def ' | 6 | ' def' | 4 |