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