rtrim
On this page
Removes trailing characters from a string.
Syntax
rtrim(<string> [, chars => <chars>])Arguments
| Argument | Type | Description |
|---|---|---|
<string> | string | String to trim. |
chars | string | Optional constant; defaults to ' \t\n\r'. Set of characters to remove: space, tab, newline, and carriage return by default. Must not be NULL. |
Returns
Returns string. Returns NULL if the input is NULL. An empty chars string leaves the input unchanged.
Examples
Clean padded event fields
Remove whitespace from the end of imported labels. Brackets make the remaining spaces visible in the result.
VALUES ('checkout '), ('catalog ')
SELECT $0 AS raw_label
SELECT '[' || raw_label || ']' AS before, '[' || rtrim(raw_label) || ']' AS after+--------------+------------+
| before | after |
+--------------+------------+
| [checkout ] | [checkout] |
| [catalog ] | [catalog] |
+--------------+------------+Remove producer formatting
Specify which characters to remove:
SELECT rtrim('checkout///', chars => '/') AS service+----------+
| service |
+----------+
| checkout |
+----------+chars is a set of individual characters to remove, not a literal prefix or suffix to match.