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 │
└───────────────────────────────────────────────────────────────────────────────────────────────────────────┘