Manuals/calci/REPLACEARRAY
Jump to navigation
Jump to search
REPLACEARRAY(Array,Match,Replacement)
- where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is the original or old array
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Match} is the matching character in old array
- Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle 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.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} can be array characters or text. Characters or text should be written in double quotes ("").
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Match} can be a character. If it does not match, original array is displayed as it is.
- Argument Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Replacement} 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