Manuals/calci/REPLACE - Revision history

Devika at 21:31, 13 August 2018

2018-08-13T21:31:28Z

Devika at 21:31, 13 August 2018

2018-08-13T21:31:06Z

Devika at 21:30, 13 August 2018

2018-08-13T21:30:50Z

Jayaram at 12:16, 14 March 2017

2017-03-14T12:16:42Z

Swapna at 14:13, 29 April 2015

2015-04-29T14:13:08Z

Swapna at 13:28, 28 December 2013

2013-12-28T13:28:49Z

Swapna at 13:26, 28 December 2013

2013-12-28T13:26:47Z

Swapna at 13:19, 28 December 2013

2013-12-28T13:19:38Z

Show changes

MassBot1: Created page with "
'''REPLACE'''
2013-10-25T02:43:26Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''REPLACE'''

'''REPLACE'''('''otxt''','''snum''','''noc''','''ntext''')

where otx'''t''' is text that want to replace some characters and

'''snum''' is the position of the character in otxt and

'''noc''' is the number of characters in otxt and

ntxt is the text that will replace characters in otxt.

</div>
----
<div id="1SpaceContent" class="zcontent" align="left">

'''REPLACE'''('''otxt''','''snum''','''noc''','''ntext''')

where otx'''t''' is text that want to replace some characters and

'''snum''' is the position of the character in otxt and

'''noc''' is the number of characters in otxt and

ntxt is the text that will replace characters in otxt.

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

REPLACE

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

Let’s see an example in (Column1 Row 1)

I.e.C1R1 =Inspiration

<nowiki>=REPLACE(C1R1,5,3,”@”) is Insp@tion</nowiki>

</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| class=" " | Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class=" " | Inspiration
| class="sshl_f" | Insp@tion
|
| class=" sshl_f " |
|- class="even"
| class=" " | Row2
| class="sshl_f" |
| class="sshl_f SelectTD SelectTD" |
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
|
|
|- class="odd"
| Row3
| class=" sshl_f " |
|
|
|
|- class="even"
| Row4
|
|
|
| class=" " |
|- class="odd"
| class=" " | Row5
|
|
|
|
|- class="even"
| Row6
|
|
|
|
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

@@ Line 3: / Line 3: @@
 *where <math>Old-Text</math> is the original or old text
 *<math>Start-Num</math> is the character position in old text
-*<math>Num_Chars</math> is the number of characters to be replaced in old text
+*<math>Num-Chars</math> is the number of characters to be replaced in old text
-*<math>New_Text</math> is the new text that replaces the characters in old text
+*<math>New-Text</math> is the new text that replaces the characters in old text
 **REPLACE(), replaces characters within text.

← Older revision		Revision as of 21:31, 13 August 2018
Line 1:		Line 1:
−	~~=REPLACE(otext, snum, noc, ntext)=~~
	<div style="font-size:30px">'''REPLACE (Old_Text,Start_Num,Num_Chars,New_Text) '''</div><br/>		<div style="font-size:30px">'''REPLACE (Old_Text,Start_Num,Num_Chars,New_Text) '''</div><br/>

@@ Line 1: / Line 1: @@
 =REPLACE(otext, snum, noc, ntext)=
-*where <math>otext</math> is the original or old text
+*where <math>Old-Text</math> is the original or old text
-*<math>snum</math> is the character position in old text
+*<math>Start-Num</math> is the character position in old text
-*<math>noc</math> is the number of characters to be replaced in old text
+*<math>Num_Chars</math> is the number of characters to be replaced in old text
-*<math>ntext</math> is the new text that replaces the characters in old text
+*<math>New_Text</math> is the new text that replaces the characters in old text
+**REPLACE(), replaces characters within text.
 == Description ==
-REPLACE(otext, snum, noc, ntext)
+REPLACE (Old_Text,Start_Num,Num_Chars,New_Text)
 For Example,
@@ Line 18: / Line 18: @@
 In above example, original text is replaced with new text from 4th character to next 4 characters.
-*<math>otext</math> and <math>ntext</math> should be enclosed in quotes.
+*<math>Old-Text</math> and <math>New-Text</math> should be enclosed in quotes.
-*<math>snum</math> and <math>noc</math> should be positive numbers.
+*<math>Start-Num</math> and <math>Num-Chars</math> should be positive numbers.
-*If <math>snum</math> and <math>noc</math> are non-integers, they are truncated.
+*If <math>Start-Num</math> and <math>Num-Chars</math> are non-integers, they are truncated.
-*If <math>snum</math> &gt; 'length of <math>otext</math>' , Calci assumes it to be '0'(zero) and new text is appended before old text.
+*If <math>Start-Num</math> &gt; 'length of <math>Old-Text</math>' , Calci assumes it to be '0'(zero) and new text is appended before old text.
 *If any arguments are invalid, Calci displays an #ERROR message.

← Older revision		Revision as of 12:16, 14 March 2017
Line 78:		Line 78:

	*[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 64: / Line 64: @@
   =REPLACE(A3,6,1,"fghijk") : Replaces 6th character from old text with lower case "fghijk". Returns '''ABCDEfghijk''' as output.
   =REPLACE(A4,8,1,"Apple ") : Appends "Apple " before old text as snum is greater than length of old text. Returns '''Apple Mango''' as output.
 == See Also ==

@@ Line 30: / Line 30: @@
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class="ssh1_f" |ColumnA
+| class="ssh1_f" |'''ColumnA'''
-| class="  " |ColumnB
+| class="  " |'''ColumnB'''
-| class="  " |ColumnC
+| class="  " |'''ColumnC'''
 |- class="odd"