Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Removes all space from text, except for single spaces between words.
Syntax
TRIM (text )
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| text |
Required |
String |
The text from which you want to remove spaces. |
Return value
String
Remarks
You can use the TRIM function on text that you have received from another application that may have irregular spacing.
Example
TRIM ("January 1, 2003 ")
Returns "January 1, 2003".