Changes

Manuals/calci/LEFT (view source)

Revision as of 21:40, 27 January 2014

762 bytes removed , 21:40, 27 January 2014

no edit summary

Line 1: Line 1: −

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

+

=LEFT(Text, Number_chars)=

−

~~==Description==~~

+

where,

+

*<math>Text</math> is a text string containing characters to extract,

+

*<math>Number_chars</math> represents the number of characters to be extracted.

−

~~'''~~LEFT~~'''~~(~~Text, Number_chars~~)

+

LEFT() displays the specified number of characters from a text string.

−

~~where,~~

+

== Description ==

−

~~'''Text''' - is the text string to extract.~~

+

LEFT(txt)

−

'''~~Number_chars~~''' ~~- represents the number of charcaters you want LEFT to extract~~.

+

e.g. LEFT("String",2) displays '''St''' as a result.

−

</~~div~~>

+

*LEFT counts 1 byte per characters. LEFT works with the languages that use 'Single Byte Character Set' (SBCS).

−

~~----~~

+

*<math>Text</math> can be any string containing characters, numbers, symbols, blankspaces etc.

−

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

+

*If argument <math>Text</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").

+

*Argument <math>Number_chars</math> indicates the number of characters to be displayed from a text string. <math>Number_chars</math> should be >0.

+

*If <math>Number_chars</math> >'length of text', Calci displays the entire text.

+

*If <math>Number_chars</math> is omitted, Calci assumes it to be 1.

−

~~LEFT retuns the charcater from text string, based on number of characters.~~

+

== Examples ==

−

~~</div>~~

+

Consider the following examples as input to LEFT() function.

−

~~----~~

−

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

−

~~If Number_chars <= 0,LEFT returns #ERROR.~~

−

~~If Number_chars > length of text, it returns all of text.~~

−

~~If Number_chars is omitted, it is considered as 1.~~

−

~~</div>~~

−

~~----~~

−

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

−

~~LEFT~~

−

~~</div></div>~~

−

~~----~~

−

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

−

~~Lets see an example in (Column1, Row2)~~

−

~~<nowiki>=LEFT(B1C1,2)</nowiki>~~

−

~~LEFT returns JO.~~

−

~~Lets see an another example in (Column1,Row3)~~

−

~~<nowiki>=LEFT(B1C1)</nowiki>~~

−

~~LEFT returns J(if omitted,considered as 1).~~

−

~~Consider an example in (Column1, Row4)~~

−

~~<nowiki>=LEFT(B1C1,20)</nowiki>~~

−

~~LEFT returns JOHN SMITH(Number_chars> length of text).~~

−

~~</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>~~

−

~~----~~

{| id="TABLE3" class="SpreadSheet blue"

|- class="even"

−

| class=" " |

+

| class="sshl_f" |Wel-Come

−

~~| Column1~~

−

~~| Column2~~

−

~~| Column3~~

−

~~| Column4~~

−

|- ~~class="odd"~~

−

~~| class=" " | Row1~~

−

~~| class=" " | JOHN SMITH~~

−

~~| class=" " |~~

−

~~| class=" " |~~

−

~~| class=" " |~~

−

~~|- class="even"~~

−

~~| class=" " | Row2~~

−

~~| class="sshl_f" | JO~~

−

~~| class=" " |~~

| class=" " |

+

|- class="odd"

−

~~| Row3~~

+

| class="sshl_f" |JOHN SMITH

−

| class="sshl_f" | J

−

~~| class=" " |~~

| class=" " |

+

|- class="even"

−

~~| Row4~~

+

| class="sshl_f" |123*123

−

| class="sshl_f" | ~~JOHN SMITH~~

−

~~| class=" " |~~

| class=" " |

+

|- class="odd"

−

| class=" ~~" | Row5~~

+

| class="sshl_f" |

−

~~| class=" SelectTD ChangeBGColor SelectTD" |~~

−

−

~~| class=" " |~~

−

~~| class=" " |~~

−

~~| class=" " |~~

−

~~|- class="even"~~

−

~~| Row6~~

−

~~| class=" " |~~

−

~~| class="~~ " |

| class=" " |

|}

+

=LEFT(A1,8) : Displays first 8 characters in a string from cell A1. Displays '''Wel-Come''' as the output.

+

=LEFT(A2,5) : Displays first 5 characters in a string from cell A2. Displays '''JOHN ''' as the output. Space Character is also counted.

+

=LEFT(A3,4) : Displays first 4 characters in a string from cell A3. Displays '''123*''' as the output.

+

=LEFT("Good Morning",20) :Displays the full text string '''Good Morning''' as the output.

+

== See Also ==

+

*[[Manuals/calci/LEFTB | LEFTB]]

+

== References ==

+

*[http://en.wikipedia.org/wiki/String_(computer_science) String]

Swapna

writer

2,661

edits