trim(LEADING | TRAILING | BOTH, {chars}, {str})

Removes leading or trailing characters from a string. If no characters are specified, the function removes blank spaces.

note: The trim function isn’t supported in Analytics Studio. An error occurs when the function is used in the UI. The function is available using the Query API. For more information, see Query CRM Analytics Data with the Query API.

• LEADING

  • : Optional. Specify to remove characters from the beginning of the string.

• TRAILING

  • : Optional. Specify to remove characters from the end of the string.

• BOTH

  • : Optional. Specify to remove characters from both the start and end of the string.

If LEADING, TRAILING, or BOTH aren't specified, trim() defaults to BOTH.

Example

This example shows all variations of the trim() function for removing the characters "A", "b", and "n" from the beginning, end, or both sides of the City field string.

SELECT City, Trim('Abn' FROM City) as TrimCity, Trim(LEADING 'Abn' FROM City) as LTrimCity, Trim(TRAILING 'Abn' FROM City) as RTrimCity, Trim(BOTH 'Abn' FROM City) as BothTrimCity
FROM "Superstore"
GROUP BY City
LIMIT 5;