Removes leading, trailing, and redundant spaces from a text string, or from each element of a text list.
@Trim( string )
string
Text or text list.
trimmedString
Text or text list. The string, with extra spaces removed.
If a text string is all spaces, @Trim returns an empty string (length of 0). If an element of a text list is all spaces, @Trim removes the element. If all elements of a text list are all spaces, @Trim returns an empty string.
This function removes only spaces, not other whitespace characters such as tabs and newlines. To remove whitespace characters, you might first convert them to spaces with @ReplaceSubstring.
@Trim(@UpperCase("Robert Smith "))
@UpperCase(@Trim(" Robert Smith"))
@Trim(Topic)
@Trim(City:StateOrProvince:Country)
@Trim(@Text(@Second(Date)))
@Trim(@ReplaceSubstring(@ThisValue; @Char(9) : @NewLine; " "))
Trim function of LotusScript® language