Newer Version Available

This content describes an older version of this product. View Latest

rtrim()

Removes the specified characters from the end of a string.

Syntax

rtrim(string,substr)

Usage

Removes every instance of each character in substr from the end of string. This function is case-sensitive. To remove trailing spaces, do not specify a value for substr.

Example

This example shows that rtrim removes the specified characters from the end of a string. This function is case-sensitive.

1q = load "test";
2q = foreach q generate 'Company' as 'Company', rtrim('Company',"abc") as 'rtrim abc',
3    rtrim('Company',"cba") as 'rtrim cba', rtrim('Company',"ab") as 'rtrim ab', 
4    rtrim('Company',"ac") as 'rtrim ac';

Diagram showing number of close opps, grouped by day of the week they were closed.