Manuals/calci/REPLACEB - Revision history

Devika at 22:14, 13 August 2018

2018-08-13T22:14:02Z

2018-08-13T22:13:37Z

2017-03-14T12:17:15Z

2015-04-30T03:02:37Z

Examples

2015-04-29T20:41:42Z

2014-02-11T16:05:05Z

2013-12-29T20:56:25Z

2013-12-28T23:45:16Z

2013-12-28T23:33:25Z

2013-12-28T23:32:59Z

← Older revision		Revision as of 22:14, 13 August 2018
Line 1:		Line 1:
−	~~=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/>		<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, '''Old_Text''' is the original or old text

@@ Line 1: / Line 1: @@
 =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
 *'''Start_Num''' represents the character position in old text
-*'''Num_Char''' represents the number of characters to be replaced in old text
+*'''Num_Chars''' 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
+**REPLACEB(), replaces characters within text.REPLACEB is intended for use with languages that use the double-byte character set (DBCS).
 == Description ==
@@ Line 16: / Line 15: @@
 *REPLACEB is intended for languages that use double-byte character set (DBCS).
 *If '''Start_Num''' &lt; 1, Calci displays #N/A message.
-*If '''Num_Char''' &lt; 1, Calci displays #N/A message.
+*If '''Num_Chars''' &lt; 1, Calci displays #N/A message.
 == Examples ==

← Older revision		Revision as of 12:17, 14 March 2017
Line 66:		Line 66:

	*[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 ]]

@@ Line 52: / Line 52: @@
   =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.
 ==Related Videos==

← Older revision		Revision as of 20:41, 29 April 2015
Line 54:		Line 54:

	<font color ="Red">Need to give examples with characters/language supporting DBCS </font>		<font color ="Red">Need to give examples with characters/language supporting DBCS </font>
		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|BB-G5ucpy4I\|280\|center\|REPLACEB}}
		+
	== See Also ==		== See Also ==

← Older revision		Revision as of 16:05, 11 February 2014
Line 53:		Line 53:
	=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.

		+	<font color ="Red">Need to give examples with characters/language supporting DBCS </font>
	== See Also ==		== See Also ==

@@ Line 1: / Line 1: @@
 =REPLACEB(Old_Text, Start_Num, Num_Char, New_Text)=
-*where, <math>Old &#95; Text</math> is the original or old text
+*where, <math>Old_Text</math> is the original or old text
 *<math>Start &#95; Num</math> represents the character position in old text
 *<math>Num &#95; Char</math> represents the number of characters to be replaced in old text

@@ Line 2: / Line 2: @@
 *where, <math>Old&#95;Text</math> is the original or old text
-*<math>Start&#95;Num</math> represents the character position in old text
+*<math>Start &#95; Num</math> represents the character position in old text
-*<math>Num&#95;Char</math> represents the number of characters to be replaced in old text
+*<math>Num &#95; Char</math> represents the number of characters to be replaced in old text
-*<math>New&#95;Text</math> is the new text with which specified number of characters in old text are replaced
+*<math>New &#95; 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.
@@ Line 15: / Line 15: @@
 *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 <math>Start&#95;Num</math> &lt; 1, Calci displays #N/A message.
+*If <math>Start &#95; Num</math> &lt; 1, Calci displays #N/A message.
-*If <math>Num&#95;Char</math> &lt; 1, Calci displays #N/A message.
+*If <math>Num &#95; Char</math> &lt; 1, Calci displays #N/A message.
 == Examples ==