RTRIM

Learn how to use the RTRIM string function in PlaidCloud Lakehouse. Removes all occurrences of any character present in the specified trim string from the...

Removes all occurrences of any character present in the specified trim string from the right side of the string.

See also:

Analyze Syntax

func.rtrim(<string>, <trim_string>)

Analyze Examples

func.rtrim('databend'xx, 'x')
┌────────────────────────────────┐
│ func.rtrim('databendxx', 'x')  │
├────────────────────────────────┤
│ databend                       │
└────────────────────────────────┘

SQL Syntax

RTRIM(<string>, <trim_string>)

SQL Examples

SELECT RTRIM('databendxx', 'x'), RTRIM('databendxx', 'xy');

┌──────────────────────────────────────────────────────┐
│ rtrim('databendxx', 'x') │ rtrim('databendxx', 'xy') │
├──────────────────────────┼───────────────────────────┤
│ databend                 │ databend                  │
└──────────────────────────────────────────────────────┘