Difference between revisions of "Manuals/calci/REPLACEARRAY"
Jump to navigation
Jump to search
(Created page with "=REPLACEARRAY(Array,Match,Replacement)= *where <math>Array</math> is the original or old text *<math>Match</math> is the matching character in old text *<math>Replacement</ma...") |
|||
| Line 1: | Line 1: | ||
=REPLACEARRAY(Array,Match,Replacement)= | =REPLACEARRAY(Array,Match,Replacement)= | ||
| − | *where <math>Array</math> is the original or old | + | *where <math>Array</math> is the original or old array |
| − | *<math>Match</math> is the matching character in old | + | *<math>Match</math> is the matching character in old array |
| − | *<math>Replacement</math> is the new | + | *<math>Replacement</math> is the new character that replaces the matching characters in old array |
| − | REPLACEARRAY() replaces the characters from the original | + | REPLACEARRAY() replaces the characters from the original array with mentioned characters or string. |
| Line 16: | Line 16: | ||
REPLACEARRAY("WELCOME","L","***") returns ''WE***COME'' | REPLACEARRAY("WELCOME","L","***") returns ''WE***COME'' | ||
| − | In above example, original text is replaced with new text | + | In above example, original text is replaced with new text for the 3rd character. |
| − | *<math> | + | *<math>Array</math> can be array characters or text. Characters or text should be written in double quotes (""). |
| − | *<math> | + | *<math>Match</math> can be a character. If it does not match, original array is displayed as it is. |
| − | + | *Argument <math>Replacement</math> can be a single character or a string. | |
| − | * | ||
*If any arguments are invalid, Calci displays an #ERROR message. | *If any arguments are invalid, Calci displays an #ERROR message. | ||
== Examples == | == Examples == | ||
| − | + | #=REPLACEARRAY("STRING","R","%%%") = ST%%%ING | |
| + | #=REPLACEARRAY(["RED", "GREEN","BLUE"],"GREEN","PINK") = RED PINK BLUE | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Related Videos== | ==Related Videos== | ||
Revision as of 05:22, 14 May 2017
REPLACEARRAY(Array,Match,Replacement)
- where is the original or old array
- is the matching character in old array
- is the new character that replaces the matching characters in old array
is the original or old array
is the matching character in old array
is the new character that replaces the matching characters in old arrayREPLACEARRAY() replaces the characters from the original array with mentioned characters or string.
Description
REPLACEARRAY(Array,Match,Replacement)
For Example,
REPLACEARRAY("WELCOME","L","***") returns WE***COME
In above example, original text is replaced with new text for the 3rd character.
- can be array characters or text. Characters or text should be written in double quotes ("").
- can be a character. If it does not match, original array is displayed as it is.
- Argument can be a single character or a string.
- If any arguments are invalid, Calci displays an #ERROR message.
Examples
- =REPLACEARRAY("STRING","R","%%%") = ST%%%ING
- =REPLACEARRAY(["RED", "GREEN","BLUE"],"GREEN","PINK") = RED PINK BLUE
Related Videos
See Also
References