TRIM

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Removes specified characters from the start, end, or both ends of a string.

  • <string>: The string to trim.
  • mode: Where to trim from (leading, trailing, or both). Defaults to both.
  • characters: The characters to remove. Defaults to space.

Returns a text value with specified characters removed.

  • Removes individual characters from the set, not the string as a pattern.
  • Default behavior removes spaces from both ends.

Remove specified characters from both ends.

Returns 'Tom', removing all x, y, and z characters from both ends.