BTRIM

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Removes specified characters from both the start and end of a string.

1btrim(<string> [, characters])

• <string>: The string to trim.

• characters: The characters to remove. Defaults to the space character.

Returns a text string with specified characters removed from both ends.

• Removes individual characters from the set, not the string as a pattern.
• Continues removing until it encounters a character not in the set.

Remove specified characters from both ends.

1SELECT btrim('xyxtrimyyx', 'xyz') AS result;

Returns 'trim'.

• String Types