Removes leading and trailing spaces from a given string.
text (required) Text or a column of text.
Trim(” John Doe “)
- Returns “John Doe”
More About Text Functions
Text functions analyze or manipulate string data and are useful sanitizing string input.
When inputting a string, use quotation marks to indicate it as a string. “This is read as a string”
If you would like to include quotes in your string, you can use a slash \ to indicate the following quote is part of the string. “\”This is a string with quotes\”” will display as “This is a string with quotes”