Differences

This shows you the differences between two versions of the page.

--- syntax:functions:removestart [2015/03/27 17:02] – elenap
+++ syntax:functions:removestart [2021/08/15 02:37] – craigt
@@ Line 1: / Line 1: @@
-====== RemoveStart(text, N) ======
+======RemoveStart(text, length) ======
+Category:  Text function
-Returns the //'text'// without the first //N// characters including spaces. Parameter //N// must be greater than 0.
+\\
+=====Description=====
+This function returns //text// excluding the first //length// characters, including spaces.
-Note that the expression does not require to use single quote signs ('X') around the number N.
+\\
+=====Arguments=====
+^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//.|
-^  Example  ^  Result  ^
+**Return value type:** Text
-|  RemoveStart( '(555)555-5555', 5 )  |  555-5555  |
-|  removestart('the company',4)  |  555-5555  |
+\\
+=====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:remove|Remove(text, start, length)]]
+  * [[syntax:functions:removechars|RemoveChars(text, string)]]
+  * [[syntax:functions:removestart|RemoveEnd(text, length)]]
-=== See also ===
-  * [[syntax:functions:keepafter]]
-  * [[syntax:functions:removeend]]