User Tools

Site Tools


RemoveStart(text, length)

Category: Text function


This function returns text excluding the first length characters, including spaces.


textTextAny text value from which the leading length characters are removed.
lengthNumber (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)

See also

syntax/functions/removestart.txt · Last modified: 2021/08/15 02:54 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki