RTrim - script and chart function

Overview

Open the Data load editor and add the load script below to a new tab.

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.

The output of the RTrim function removed all trailing spaces to the right of the original text but retained all leading spaces.

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 tab.

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.

The output shows that the RTrim function removed all trailing spaces from the original string values in CustomerName.

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 tab.

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.

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  '];