TRIM

The TRIM function removes leading and trailing spaces from a text string, but retains spaces that are between words.

Syntax

trim(value:string)

Arguments

value - Required. A text string.

Example

trim('   Forecast    ')

Returns “Forecast".