RTRIM function - Amazon Redshift

RTRIM function

The RTRIM function trims a specified set of characters from the end of a string. Removes the longest string containing only characters in the trim characters list. Trimming is complete when a trim character does not appear in the input string.

Syntax

RTRIM( string, trim_chars )

Arguments

string

A string column, expression, or string literal to be trimmed.

trim_chars

A string column, expression, or string literal that represents the characters to be trimmed from the end of string. If not specified, a space is used as the trim character.

Return type

A string that is the same data type as the string argument.

Example

The following example trims leading and trailing blanks from the string ' abc ':

select ' abc ' as untrim, rtrim(' abc ') as trim; untrim | trim ----------+------ abc | abc

The following example removes the trailing 'xyz' strings from the string 'xyzaxyzbxyzcxyz'. The trailing occurrences of 'xyz' are removed, but occurrences that are internal within the string are not removed.

select 'xyzaxyzbxyzcxyz' as untrim, rtrim('xyzaxyzbxyzcxyz', 'xyz') as trim; untrim | trim -----------------+----------- xyzaxyzbxyzcxyz | xyzaxyzbxyzc

The following example removes the trailing parts from the string 'setuphistorycassettes' that match any of the characters in the trim_chars list 'tes'. Any t, e, or s that occur before another character that is not in the trim_chars list at the ending of the input string are removed.

SELECT rtrim('setuphistorycassettes', 'tes'); rtrim ----------------- setuphistoryca

The following example trims the characters 'Park' from the end of VENUENAME where present:

select venueid, venuename, rtrim(venuename, 'Park') from venue order by 1, 2, 3 limit 10; venueid | venuename | rtrim --------+----------------------------+------------------------- 1 | Toyota Park | Toyota 2 | Columbus Crew Stadium | Columbus Crew Stadium 3 | RFK Stadium | RFK Stadium 4 | CommunityAmerica Ballpark | CommunityAmerica Ballp 5 | Gillette Stadium | Gillette Stadium 6 | New York Giants Stadium | New York Giants Stadium 7 | BMO Field | BMO Field 8 | The Home Depot Center | The Home Depot Cente 9 | Dick's Sporting Goods Park | Dick's Sporting Goods 10 | Pizza Hut Park | Pizza Hut

Note that RTRIM removes any of the characters P, a, r, or k when they appear at the end of a VENUENAME.