TRIM

Removes leading, trailing and repeated whitespace from a text string

TRIM( string)

Removes leading, trailing, and repeated whitespace from a text string.

Arguments

Input	Description
text	Text(s) to strip of whitespace

Output

Outputs string without excess whitespaces

Example

TRIM("  leeroy   jenkins ")
>>leeroy jenkins