TRIM

Returns text with leading and trailing spaces removed.

Sample Usage

TRIM(Campaign)

Syntax

TRIM(X)

Parameters:

  • X - literal text, a field, or an expression containing at least one field.

Examples

Example Formula Input Output
TRIM(Campaign)
"   Summer Sale "
"Summer Sale"
TRIM(Campaign)
"Summer @2019 Sale   "
"Summer @2019 Sale"

Related resources

Was this helpful?
How can we improve it?