Difference between revisions of "Manuals/calci/REPLACE"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
*where <math>Old-Text</math> is the original or old text | *where <math>Old-Text</math> is the original or old text | ||
*<math>Start-Num</math> is the character position in old text | *<math>Start-Num</math> is the character position in old text | ||
| − | *<math> | + | *<math>Num-Chars</math> is the number of characters to be replaced in old text |
| − | *<math> | + | *<math>New-Text</math> is the new text that replaces the characters in old text |
**REPLACE(), replaces characters within text. | **REPLACE(), replaces characters within text. | ||
Latest revision as of 15:31, 13 August 2018
REPLACE (Old_Text,Start_Num,Num_Chars,New_Text)
- 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 Old-Text} is the original or old text
- 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 Start-Num} is the character position in old text
- 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 Num-Chars} is the number of characters to be replaced in old text
- 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 New-Text}
is the new text that replaces the characters in old text
- REPLACE(), replaces characters within text.
Description
REPLACE (Old_Text,Start_Num,Num_Chars,New_Text)
For Example,
REPLACE("WELCOME",4,4,"-COME") returns WEL-COME
In above example, original text is replaced with new text from 4th character to next 4 characters.
- 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 Old-Text} and 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 New-Text} should be enclosed in 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 Start-Num} and 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 Num-Chars} should be positive numbers.
- If 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 Start-Num} and 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 Num-Chars} are non-integers, they are truncated.
- If 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 Start-Num} > 'length of 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 Old-Text} ' , Calci assumes it to be '0'(zero) and new text is appended before old text.
- If any arguments are invalid, Calci displays an #ERROR message.
Examples
| ColumnA | ColumnB | ColumnC |
| 123456 | ||
| replace | ||
| ABCDEF | ||
| Mango | ||
=REPLACE(A1,2,1,"two") : Replaces second character from old text with "two". Returns 1two3456 as output. =REPLACE(A2,3,5,"PLACE") :Replaces 5 characters from old text starting from 3rd position with upper case "PLACE". Returns rePLACE as output. =REPLACE(A3,6,1,"fghijk") : Replaces 6th character from old text with lower case "fghijk". Returns ABCDEfghijk as output. =REPLACE(A4,8,1,"Apple ") : Appends "Apple " before old text as snum is greater than length of old text. Returns Apple Mango as output.
Related Videos
See Also
References