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