trim(<Text>) : Text
The trim function is used to remove leading and trailing whitespace characters from the text parameter.
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.
Type above and the results will be displayed here.