Difference between revisions of "Manuals/calci/REPLACEB"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
*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> represents the character position in old text | + | *<math>Start _ Num</math> represents the character position in old text |
| − | *<math>Num_Char</math> represents the number of characters to be replaced in old text | + | *<math>Num _ Char</math> represents the number of characters to be replaced in old text |
| − | *<math>New_Text</math> is the new text with which specified number of characters in old text are replaced | + | *<math>New _ Text</math> is the new text with which specified number of characters in old text are replaced |
REPLACEB() replaces a part of old text string with a new text string, based on the number of bytes specified. | REPLACEB() replaces a part of old text string with a new text string, based on the number of bytes specified. | ||
| Line 15: | Line 15: | ||
*This function counts and replaces specified number of byte characters with a new text string. | *This function counts and replaces specified number of byte characters with a new text string. | ||
*REPLACEB is intended for languages that use double-byte character set (DBCS). | *REPLACEB is intended for languages that use double-byte character set (DBCS). | ||
| − | *If <math>Start_Num</math> < 1, Calci displays #N/A message. | + | *If <math>Start _ Num</math> < 1, Calci displays #N/A message. |
| − | *If <math>Num_Char</math> < 1, Calci displays #N/A message. | + | *If <math>Num _ Char</math> < 1, Calci displays #N/A message. |
== Examples == | == Examples == | ||
Revision as of 17:32, 28 December 2013
REPLACEB(Old_Text, Start_Num, Num_Char, 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} represents the character position in old text
- Failed to parse (syntax error): {\displaystyle Num _ Char} represents the number of characters to be replaced in old text
- Failed to parse (syntax error): {\displaystyle New _ Text} is the new text with which specified number of characters in old text are replaced
REPLACEB() replaces a part of old text string with a new text string, based on the number of bytes specified.
Description
For Example, REPLACEB("JOHN",2,1,"$") returns J$HN
- This function counts and replaces specified number of byte characters with a new text string.
- REPLACEB is intended for languages that use double-byte character set (DBCS).
- If Failed to parse (syntax error): {\displaystyle Start _ Num} < 1, Calci displays #N/A message.
- 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 Num _ Char} < 1, Calci displays #N/A message.
Examples
| ColumnA | ColumnB | ColumnC |
| 123456 | ||
| ***** | ||
| STAR | ||
=REPLACEB(A1,1,2,"*") : Replaces first two characters from old text with "*". Returns *3456 as output. =REPLACEB(A2,2,1,"@") :Replaces first byte (2 characters) from old text with upper case "@". Returns @**** as output. =REPLACEB(A3,2,1,"aa") : Replaces 2nd character from old text with "aa". Returns SaaAR as output.