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...") |
|||
| (One intermediate revision by one other user not shown) | |||
| 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 | + | *<math>Match</math> is the matching character in old array |
| − | *<math>Match</math> is the matching character in old | + | *<math>Replacement</math> is the new character that replaces the matching characters in old array |
| − | *<math>Replacement</math> is the new | + | **REPLACEARRAY() replaces the characters from the original array with mentioned characters or string. |
| − | |||
| − | REPLACEARRAY() replaces the characters from the original | ||
| − | |||
== Description == | == Description == | ||
| − | |||
REPLACEARRAY(Array,Match,Replacement) | REPLACEARRAY(Array,Match,Replacement) | ||
| − | |||
For Example, | For Example, | ||
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== | ||
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.
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
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