Manuals/calci/RIGHT - Revision history

Swapna at 18:43, 13 May 2015

2015-05-13T18:43:03Z

Swapna at 23:04, 30 January 2014

2014-01-30T23:04:51Z

Swapna at 22:44, 30 January 2014

2014-01-30T22:44:30Z

Swapna at 22:43, 30 January 2014

2014-01-30T22:43:41Z

MassBot1: Created page with "
'''RIGHT'''
2013-10-25T02:43:33Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''RIGHT'''</font></font></font><font color="#484..."

New page
<div id="6SpaceContent" class="zcontent" align="left">

<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''RIGHT'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''txt'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,noc)</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">where t</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''xt'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is the text string containing the characters that want to pull out and noc specifies the number of characters .</font></font></font>

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

<font color="#484848"><font face="Arial, sans-serif"><font size="2">It brings the last character or characters in a text string, based on the number of characters that specify.</font></font></font>

<font color="#ff0000"><font face="Arial, sans-serif"><font size="2">'''Note:'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> RIGHT use the single-byte character set (SBCS) </font></font></font>

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

* <font color="#484848"><font face="Arial, sans-serif"><font size="2">noc must be greater than or equal to zero. </font></font></font>
* <font color="#484848"><font face="Arial, sans-serif"><font size="2">RIGHT displays all of text when noc is greater than the length of text. </font></font></font>
* <font color="#484848"><font face="Arial, sans-serif"><font size="2">When noc is omitted, it is assumed to be 1. </font></font></font>

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

RIGHT

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

<font color="#484848"><font face="Arial, sans-serif"><font size="2">Let’s see an example in (Column1 Row 1)</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">C1R1 = Stock Exchange</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e. =RIGHT(C1R1,8) is Exchange</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">///rly =RIGHT(C1R1) is e</font></font></font>

</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </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=" " | StockXPExchange
| class="sshl_f" | Exchange
| class="sshl_f" | e
| class=" sshl_f " |
|- class="even"
| class=" " | Row2
| class="sshl_f" |
|
| class=" 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 49: / Line 49: @@
   =RIGHT(A1,5) : Displays last 5 characters in a string from cell A1. Displays '''-Come''' as the output.
-  =RIGHT(A2,8) : Displays last 8 characters in a string from cell A2. Displays '''HN SMITH''' as the output. Space Character is also counted.
+  =RIGHT(A2,8) : Displays last 8 characters in a string from cell A2. Displays '''HN SMITH''' as the output. <br />Space Character is also counted.
   =RIGHT(A3,9) : Displays all characters in a string from cell A3. Displays '''123*123''' as the output.
   =RIGHTB(A3) : Displays last character in a string from cell A3. Displays '''3''' as the output.
   =RIGHT("Good Morning",7) :Displays '''Morning''' as the output.
 == See Also ==

@@ Line 51: / Line 51: @@
   =RIGHT(A2,8) : Displays last 8 characters in a string from cell A2. Displays '''HN SMITH''' as the output. Space Character is also counted.
   =RIGHT(A3,9) : Displays all characters in a string from cell A3. Displays '''123*123''' as the output.
   =RIGHT("Good Morning",7) :Displays '''Morning''' as the output.

@@ Line 13: / Line 13: @@
 e.g. RIGHT("String",2) displays '''ng''' as a result.
-*RIGHT counts 1 byte per characters. RIGHT works with the languages that use 'Single Byte Character Set' (SBCS).
+*RIGHT counts 1 byte per character. RIGHT works with the languages that use 'Single Byte Character Set' (SBCS).
 *'''Text''' can be any string containing characters, numbers, symbols, blank spaces etc.
 *If argument '''Text''' is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+=RIGHT(Text, Number_chars)=
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''RIGHT'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''txt'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,noc)</font></font></font>
+where,
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">where t</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''xt'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">   is the text string containing the characters that want to pull out and noc  specifies the number of characters .</font></font></font>
+RIGHT() displays the last character or characters from a text string, depending on the specified number of characters.
-</div>
+== Description ==
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">It brings the last character or characters in a text string, based on the number of characters that specify.</font></font></font>
+RIGHT(txt)
-<font color="#ff0000"><font face="Arial, sans-serif"><font size="2">'''Note:'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> RIGHT use the single-byte character set (SBCS) </font></font></font>
+e.g. RIGHT("String",2) displays '''ng''' as a result.
-</div>
+*RIGHT counts 1 byte per characters. RIGHT works with the languages that use 'Single Byte Character Set' (SBCS).
-----
+*'''Text''' can be any string containing characters, numbers, symbols, blank spaces etc.
-<div id="7SpaceContent" class="zcontent" align="left">
+*If argument '''Text''' is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
-* <font color="#484848"><font face="Arial, sans-serif"><font size="2">noc must be greater than or equal to zero. </font></font></font>
+== Examples ==
-</div>
+Consider the following examples as input to RIGHT() function.
 <div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
 | class=" " |
-| Column1
 |- class="odd"
-| class=" " | Row1
+| class="sshl_f" |JOHN SMITH
-| class="  " | StockXPExchange
+| class=" " |
-| class="sshl_f" | Exchange
+| class=" " |
-| class="sshl_f" | e
 |- class="even"
-| class="  " | Row2
+| class="sshl_f" |123*123
-| class="sshl_f" |
+| class=" " |
 | class=" " |
-| class=" SelectTD SelectTD" |
 |- class="odd"
-| Row3
+| class="sshl_f" |
-| class="                                       sshl_f    " |
+| class=" " |
 | class=" " |
 |}
-<div align="left">[[Image:calci1.gif]]</div></div>
+ =RIGHT(A1,5) : Displays last 5 characters in a string from cell A1. Displays '''-Come''' as the output.
-----
+ =RIGHT(A2,8) : Displays last 8 characters in a string from cell A2. Displays '''HN SMITH''' as the output. Space Character is also counted.