FunctionsString

trim_right

Removes trailing whitespace, or characters from an optional trim-set argument, for each row.

trim_right(…) → String

Kind · scalar

Removes trailing whitespace, or characters from an optional trim-set argument, for each row.

Part of the String family.

trim_left

Removes leading whitespace, or characters from an optional trim-set argument, for each row.

trim_scale

Removes insignificant trailing zeros from the fractional part of a numeric string. If the fractional part becomes empty, the decimal point is also removed.