TRIM_TRAILING

Removes all occurrences of the specified trim string from the end of the string.

See also:

Analyze Syntax

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

Analyze Examples

func.trim_trailing('xxdatabendxx', 'x')
+------------------------------------------+
| func.trim_trailing('xxdatabendxx', 'x')  |
+------------------------------------------+
| xxdatabend                               |
+------------------------------------------+

SQL Syntax

TRIM_TRAILING(<string>, <trim_string>)

SQL Examples

SELECT TRIM_TRAILING('databendxx', 'xxx'), TRIM_TRAILING('databendxx', 'xx'), TRIM_TRAILING('databendxx', 'x');

┌───────────────────────────────────────────────────────────────────────────────────────────────────────────┐
 trim_trailing('databendxx', 'xxx')  trim_trailing('databendxx', 'xx')  trim_trailing('databendxx', 'x') 
├────────────────────────────────────┼───────────────────────────────────┼──────────────────────────────────┤
 databendxx                          databend                           databend                         
└───────────────────────────────────────────────────────────────────────────────────────────────────────────┘