From The Document Foundation Wiki
Jump to navigation Jump to search
  • The function TRIM removes one or more characters at the beginning or end of the string. Specify whether leading, trailing, or both with the keywords LEADING, TRAILING, or BOTH (default).
  • Similarly there are functions LTRIM and RTRIM which specifically remove spaces from the left and right respectively of the expression given as the parameter.
  • These function can be used in both draft and SQL mode.
  • In the example given, no keyword specifying position is given therefore the default BOTH will be applied.