Category: Text function
This function trims off all trailing spaces and other non-printing characters (see Remarks) from text. Leading spaces are preserved.
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.
trimend('Columbia ') //Returns 'Columbia'
trimend(' Columbia ') //Returns ' Columbia' (Leading spaces retained)