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" |