TRIM(x)

This function removes leading and trailing spaces from a string.

Example:

Remove leading and trailing spaces from a string: TRIM(“     Pranalytix Tutorial      “)="Pranalytix Tutorial"