Removes all leading and trailing spaces from a text string and converts multiple spaces inside that text string into single spaces.
Syntax:
TRIM( text )
Example:
TRIM(" sloppy typing ")
would return the text string "sloppy typing"
.
Revisions:
Starting with 2.24, this function can accept text strings longer than 200 characters as input.