TRIM function

Description

TRIM(str) returns a string with all all spaces removed from from str except for single spaces between words. The function removes any leading or trailing spaces and strips extra spaces between words.

Examples

TRIM(" John    Doe ") returns "John Doe"

TRIM("     ") returns an empty string (length=0)

Calculator

Related functions

• List of String functions
• LTRIM Left trim function
• RTRIM(str) Right trim function