Category: Text function
This function trims off all leading and trailing spaces, and other non-printing characters (see Remarks) from text.
| Argument | Type | Description |
|---|---|---|
| text | Text | Any text value or other value that can be implicitly converted to text if required. |
Return value type: Text
Besides spaces, it also removes other non-printing, white-space characters such as tabulations, form feeds, etc. The full list of removed white-space characters.
trim(' Columbia') //Returns 'Columbia'
trim(' Columbia ') //Returns 'Columbia'
trim(' Columbia ') //Returns 'Columbia'