RTRIM

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Removes specified characters from the end of a string.

1rtrim(<string> [, characters])

• <string>: The string to trim.

• characters: The characters to remove. Defaults to space.

Returns a text value with specified characters removed from the end.

• Removes individual characters from the set, not as a substring pattern.
• Continues removing until encountering a character not in the set.

Remove characters from the end.

1SELECT rtrim('testxxzx', 'xyz') AS result;

Returns 'test'.

• String Types