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"