Differences

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

--- syntax:functions:remove [2021/07/21 16:18] – [Examples] craigt
+++ syntax:functions:remove [2021/08/15 01:51] – craigt
@@ Line 1: / Line 1: @@
-====== Remove(text, start_pos, no_of_chars) ======
+======Remove(text, start, length) ======
 Category:  Text function
 \\
 =====Description=====
-This function removes a specified number of characters, from a specified starting point, within a text string.
+This function removes a substring of text from //text//, //length// characters long, and starting with the //start//<sup>th</sup> character.
-**Return value type:**  Text
 \\
 =====Arguments=====
-^Argument ^Type ^Description^
+^Argument^Type^Description^
-|text |Text|Any text string or value that can implicitly be converted to text.|
+|text|Text|Any text value from which the substring of text is removed.|
-|start_pos |Integer greater than 0|The N<sup>th</sup> position of the first character in //text// to start removing from.  The minimum value is 1.|
+|start|Number (Integer)|The position of the first character within //text// to be removed.|
-|no_of_chars |Integer greater than 0 |The number of characters to remove.|
+|length|Number (Integer)|The number of characters to remove.|
-\\
+**Return value type:** Text
+\\
 =====Remarks=====
-All three arguments must be supplied or a warning applies in each row of the column.
+Number values entered for //text// are implicitly converted to text.
-If //start_pos// is a position past the end of the text, nothing is removed.
+Entering a value for //start// that is past the number of characters in //text// returns the full //text// value.
-If //no_of_chars// exceeds the number of characters that can be removed, all characters from //start_pos// to the end of //text// will be removed.
+Entering a value for //length// that exceeds the number of characters after the //start// position, returns the leading characters in //text// up to the //start// position.
 \\
 =====Examples=====
+  remove('Betelgeuse', 2, 4) //Returns 'Bgeuse'
-  remove('27.03.2015', 6, 5) = '27.03'
+  remove('Pleiades', 1, 3) //Returns 'iades'
-  remove('27.03.2015', 7, 2) = '27.03.15'
-  remove('Mrs. Smith", 3, 1) = 'Mr. Smith'
-  remove(1203, 2, 2) = '13'
-  remove((10*10), 1, 1) = '00'  //removes the first single character from '100'.
-  remove('Alexander', 12, 2) = 'Alexander'  //N_start is past the end of the text - nothing is removed.
-  remove('Scott', 4, 4) = 'Sco'  //N_chars extends past the end of text; only available characters are removed.
+  remove(32876, 2, 2) //Returns '376' (Numbers implicitly converted; return value is text)
+  remove('the', 4, 3) //Returns 'the'  (Starting point past the end of the text; value returned)
+  remove('Canopus', 4, 6) //Returns 'Can'  (length is past the end of 'Canopus', leading characters returned)
 \\
-===== See also =====
+=====See also=====
-  * [[syntax:functions:mid]]
+  * [[syntax:functions:removechars|RemoveChars(text, string)]]
+  * [[syntax:functions:removeend|RemoveEnd(text, N)]]
+  * [[syntax:functions:removestart|RemoveStart(text, N)]]