Difference between revisions of "Manuals/calci/REPLACEARRAY"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | =REPLACEARRAY(Array,Match,Replacement) | + | <div style="font-size:30px">'''REPLACEARRAY(Array,Match,Replacement)'''</div><br/> |
− | |||
*where <math>Array</math> is the original or old array | *where <math>Array</math> is the original or old array | ||
*<math>Match</math> is the matching character in old array | *<math>Match</math> is the matching character in old array | ||
*<math>Replacement</math> is the new character that replaces the matching characters in old array | *<math>Replacement</math> is the new character that replaces the matching characters in old array | ||
− | + | **REPLACEARRAY() replaces the characters from the original array with mentioned characters or string. | |
− | REPLACEARRAY() replaces the characters from the original array with mentioned characters or string. | ||
− | |||
== Description == | == Description == | ||
− | |||
REPLACEARRAY(Array,Match,Replacement) | REPLACEARRAY(Array,Match,Replacement) | ||
− | |||
For Example, | For Example, | ||
Latest revision as of 22:46, 26 August 2018
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
- REPLACEARRAY() 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