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