TRIM

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.