writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 2:
Line 2: − + − + − + Line 21:
Line 21: − + Line 38:
Line 38: − Line 44:
Line 43: − Line 50:
Line 48: − Line 56:
Line 53: −
Manuals/calci/REPLACE (view source)
Revision as of 13:26, 28 December 2013
, 13:26, 28 December 2013no edit summary
*where <math>otext</math> is the original or old text
*where <math>otext</math> is the original or old text
*<math>snum</math> is the position of character in old text
*<math>snum</math> is the character position in old text
*<math>noc</math> is the number of characters
*<math>noc</math> is the number of characters to be replaced in old text
*<math>ntext</math> is the new text that replaces the characters in old text.
*<math>ntext</math> is the new text that replaces the characters in old text
REPLACE() replaces a part of the text string with a different text string.
REPLACE() replaces a part of the text string with a different text string.
*<math>snum</math> and <math>noc</math> should be positive numbers.
*<math>snum</math> and <math>noc</math> should be positive numbers.
*If <math>snum</math> and <math>noc</math> are non-integers, they are truncated.
*If <math>snum</math> and <math>noc</math> are non-integers, they are truncated.
*If <math>snum</math> is > the length of string, Calci assumes it to be '0'(zero) and new text is appended before old text.
*If <math>snum</math> > 'length of <math>otext</math>' , Calci assumes it to be '0'(zero) and new text is appended before old text.
*If any arguments are invalid, Calci displays an #ERROR message.
*If any arguments are invalid, Calci displays an #ERROR message.
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
|- class="even"
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
|- class="odd"
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="even"
|- class="even"
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
|- class="odd"