writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − + − + − − Line 15:
Line 13: − + − + Line 52:
Line 50: + + + + Line 62:
Line 64: + + + + + +
no edit summary
=REPLACEB(Old_Text, Start_Num, Num_Char, New_Text)=
<div style="font-size:30px">'''REPLACEB (Old_Text,Start_Num,Num_Chars,New_Text) '''</div><br/>
*where, '''Old_Text''' is the original or old text
*where, <math>Old_Text</math> is the original or old text
*'''Start_Num''' represents the character position in old text
*<math>Start _ Num</math> represents the character position in old text
*'''Num_Chars''' 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
*'''New_Text''' 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 characters within text.REPLACEB is intended for use with languages that use the double-byte character set (DBCS).
REPLACEB() replaces a part of old text string with a new text string, based on the number of bytes specified.
== Description ==
== Description ==
*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 '''Start_Num''' < 1, Calci displays #N/A message.
*If <math>Num _ Char</math> < 1, Calci displays #N/A message.
*If '''Num_Chars''' < 1, Calci displays #N/A message.
== Examples ==
== Examples ==
=REPLACEB(A2,2,1,"@") :Replaces first byte (2 characters) from old text with upper case "@". Returns '''@****''' 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.
=REPLACEB(A3,2,1,"aa") : Replaces 2nd character from old text with "aa". Returns '''SaaAR''' as output.
==Related Videos==
{{#ev:youtube|BB-G5ucpy4I|280|center|REPLACEB}}
== See Also ==
== See Also ==
*[http://en.wikipedia.org/wiki/Autocorrection Find and Replace]
*[http://en.wikipedia.org/wiki/Autocorrection Find and Replace]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]