User Tools

Site Tools


syntax:functions:removestart

RemoveStart(text, length)

Category: Text function


Description

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


Arguments

ArgumentTypeDescription
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


Remarks

Number values entered for text are implicitly converted to text.

Blank spaces and non-printing characters are counted as characters and removed.


Examples

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