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"
Design a Mobile Site
View Site in Mobile | Classic
Share by: