FunctionsString

trim_both

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

trim_both(…) → String

Kind · scalar

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

Part of the String family.

trim_array

Trims each element of a string array representation and returns a JSON array string. Supports optional custom trim characters.

trim_left

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