The following examples use the LTrim and RTrim functions to strip leading and trailing spaces, respectively, from a Subject field that contains the value " <-Trim-> ". It uses the Trim function alone to strip both types of spaces. The quotation marks mark the end of the string but are not part of it.
Function | Returns |
---|---|
LTrim([Subject]) |
"<-Trim-> " |
RTrim([Subject]) |
" <-Trim->" |
Trim([Subject]) |
"<-Trim->" |