FORMULA LANGUAGE

@Trim
Example

Removes leading, trailing, and redundant spaces from a text string, or from each element of a text list.

Syntax

@Trim( string )

Parameters

string


Return value

trimmedString


Usage

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.

Language cross-reference

Trim function of LotusScript language

Example
See Also