Manuals/calci/REPLACEARRAY

REPLACEARRAY(Array,Match,Replacement)

• where $Array$ is the original or old array
• $Match$ is the matching character in old array
• $Replacement$ 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.

• $Array$ can be array characters or text. Characters or text should be written in double quotes ("").
• $Match$ can be a character. If it does not match, original array is displayed as it is.
• Argument $Replacement$ 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

• REPLACEB
• SUBSTITUTE
• REPT

References

• Find and Replace

• List of Main Z Functions

• Z3 home