Difference between revisions of "Manuals/calci/REPLACEARRAY"

From ZCubes Wiki
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

  1. =REPLACEARRAY("STRING","R","%%%") = ST%%%ING
  2. =REPLACEARRAY(["RED", "GREEN","BLUE"],"GREEN","PINK") = RED PINK BLUE


Related Videos

REPLACE

See Also

References