Function: trim()

Usage

trim(<Text>) : Text

The trim function is used to remove leading and trailing whitespace characters from the text parameter.

Examples

trim(" abc ") => "abc"

reverse("Fusioo     ") => "Fusioo"

The trim() function is commonly used for removing trailing whitespace within if() function comparisons.

For example, the @City value might be "New York    " or "    New York". By using the trim() function, you can trim any user input, as shown below:

if(contains(trim(@City), "New York"), "From New York", "From outside New York"))

Learn more about how you can get started using the Formula Field.

What would you improve in this article?
Powered by:

Type above and the results will be displayed here.