writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + Line 15:
Line 15: − + − +
Manuals/calci/REPLACEB (view source)
Revision as of 23:32, 28 December 2013
, 23:32, 28 December 2013no edit summary
=REPLACEB(Old_Text, Start_Num, Num_Char, New_Text)=
=REPLACEB(Old_Text, Start_Num, Num_Char, New_Text)=
*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.
*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 ==