Difference between revisions of "Manuals/calci/SUBSTITUTE"
Jump to navigation
Jump to search
| Line 17: | Line 17: | ||
SUBSTITUTE("WELCOME", "COME", "DONE", 1) returns ''WELDONE'' | SUBSTITUTE("WELCOME", "COME", "DONE", 1) returns ''WELDONE'' | ||
| − | In above example, first | + | In above example, first instance of old text is replaced with new text. |
*SUBSTITUTE function can be used to replace specific occurrences of the text. | *SUBSTITUTE function can be used to replace specific occurrences of the text. | ||
| Line 24: | Line 24: | ||
*If string specified in <math>otext</math> is not part of the reference string <math>txt</math>, Calci returns the original string <math>txt</math> as a result. | *If string specified in <math>otext</math> is not part of the reference string <math>txt</math>, Calci returns the original string <math>txt</math> as a result. | ||
*Argument <math>instnum</math> is optional. If omitted, all instances mentioned in old text are replaced by new text. | *Argument <math>instnum</math> is optional. If omitted, all instances mentioned in old text are replaced by new text. | ||
| − | *<math>instnum</math> should be | + | *<math>instnum</math> should be an integer > 0, else Calci displays #NULL error message. |
== Examples == | == Examples == | ||
| Line 48: | Line 48: | ||
|} | |} | ||
| − | =SUBSTITUTE(A1,"TUTE", "TUTION",1) : Replaces first instance of old text with new text. Returns '''SUBSTITUTION''' as output. | + | =SUBSTITUTE(A1,"TUTE", "TUTION",1) : Replaces first instance of old text with new text. <br />Returns '''SUBSTITUTION''' as output. |
=SUBSTITUTE(A2,"123","888",2) :Replaces second instance of old text with new text. Returns '''abc123abc888''' as output. | =SUBSTITUTE(A2,"123","888",2) :Replaces second instance of old text with new text. Returns '''abc123abc888''' as output. | ||
=SUBSTITUTE(A2,"123","888") : Replaces all instances of old text with new text. Returns '''abc888abc888''' as output. | =SUBSTITUTE(A2,"123","888") : Replaces all instances of old text with new text. Returns '''abc888abc888''' as output. | ||
Revision as of 16:08, 10 February 2014
SUBSTITUTE(txt, otext, ntext, instnum)
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 txt} is the text or reference to cell containing text, from which certain string is to be substituted,
- 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 otext} is the old text to be replaced,
- 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 ntext} is the new text that replaces the characters 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 instnum} is the instance number that specifies which occurrence needs to be replaced.
SUBSTITUTE() substitutes specific instances of old text with new text in a text string.
Description
SUBSTITUTE(txt, otext, ntext, instnum)
For Example,
SUBSTITUTE("WELCOME", "COME", "DONE", 1) returns WELDONE
In above example, first instance of old text is replaced with new text.
- SUBSTITUTE function can be used to replace specific occurrences of the text.
- 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 txt} is entered directly as a part of argument, it should be enclosed in quotation marks (e.g. "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 otext} 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 ntext} should be enclosed in quotation marks (e.g. "TEXT").
- If string specified in 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 otext} is not part of the reference string 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 txt} , Calci returns the original string 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 txt} as a result.
- 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 instnum} is optional. If omitted, all instances mentioned in old text are replaced by new 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 instnum} should be an integer > 0, else Calci displays #NULL error message.
Examples
| SUBSTITUTE | ||
| abc123abc123 | ||
| Cost Price |
=SUBSTITUTE(A1,"TUTE", "TUTION",1) : Replaces first instance of old text with new text.
Returns SUBSTITUTION as output. =SUBSTITUTE(A2,"123","888",2) :Replaces second instance of old text with new text. Returns abc123abc888 as output. =SUBSTITUTE(A2,"123","888") : Replaces all instances of old text with new text. Returns abc888abc888 as output. =SUBSTITUTE(A3,"Cost", "Selling") : Returns Selling Price as output.