Category: Text function
This function returns text excluding the first length characters, including spaces.
| Argument | Type | Description |
|---|---|---|
| text | Text | Any text value from which the leading length characters are removed. |
| length | Number (Greater than 0) | The number of characters to remove from the start of text. |
Return value type: Text
Number values entered for text are implicitly converted to text.
Blank spaces and non-printing characters are counted as characters and removed.
removestart('1000 USD', 5) //Returns 'USD'
removestart('October 1, 2014', 11) //Returns '2014'
removestart(100200, 3) //Returns '200' (Number implicitly converted to text; value is returned as text)
removeend('North' & char(10) & 'South', 7) //Returns 'outh' (the line space - char(10) - counts as a character)