writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="6SpaceContent" class="zcontent" align="left">+ − + + + − where,+ − '''Text''' - is the text string to extract.+ − '''Number_chars''' - represents the number of charcaters you want LEFT to extract.+ − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − + + + + + + + − </div>+ − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − If Number_chars <= 0,LEFTB 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"> − − LEFTB − − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − Lets see an example in (Column1, Row2) − − <nowiki>=LEFTB(R1C1,2)</nowiki> − − LEFTB returns JO. − − Lets see an another example in (Column1,Row3) − − <nowiki>=LEFTB(R1C1)</nowiki> − − LEFTB returns J(if omitted,considered as 1). − − Consider an example in (Column1, Row4) − − <nowiki>=LEFTB(R1C1,20)</nowiki> − − LEFTB 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> − ---- − |+ Default Calci + + − | Column1+ − | Column2 − | Column3 − | Column4 − + − + − + − + − | − + − + − + − + − | − | Row3+ − | class="sshl_f" | J+ − |+ − | − | − |- class="even" − | Row4 − − | − | − | − |- class="odd" − | class=" " | Row5 − | class=" " | − | − | − − − | Row6 − − − <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div> − | − − {| id="TABLE3_menu"+ − | align="right" | TABLE3+ − | <span align="left">[[Image:calci1.gif]]</span>+ − |+ − |+ − [[Image:bold.gif]]+ − |+ − [[Image:italic.gif]]+ − |+ − [[Image:normal.gif]]+ − |+ − [[Image:underline.gif]]+ − | − [[Image:border.gif]] − | − [[Image:numbers.gif]] − | − [[Image:sort.gif]] − | − − − [[Image:graphs.gif]] − | $ − |} − </div>+ − ----
no edit summary
=LEFTB(Text, Number_bytes)=
'''LEFTB'''(Text, Number_chars)
where,
*'''Text''' is a text string containing characters to extract,
*'''Number_bytes''' represents the number of characters to be extracted.
LEFTB() displays the characters from a text string, depending on specified number of bytes.
== Description ==
LEFTB(Text, Number_bytes)
e.g. LEFTB("String",2) displays '''St''' as a result.
LEFTB returns the first character or characters in a text string, based on the number of bytes you specify. LEFTB is intended for use with languages that use the double-byte character set (DBCS).
*LEFTB counts 2 bytes per character when system is set to language supporting DBCS, else counts 1 byte per character.
*LEFTB works with the languages that use 'Double Byte Character Set' (DBCS).
*'''Text''' can be any string containing characters, numbers, symbols, blankspaces etc.
*If argument '''Text''' is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
*Argument '''Number_bytes''' indicates the number of byte characters to be displayed from a text string. '''Number_bytes''' should be >0.
*If '''Number_bytes''' >'length of text', Calci displays the entire text.
*If '''Number_bytes''' is omitted, Calci assumes it to be 1.
== Examples ==
Consider the following examples as input to LEFTB() function.
<div id="2SpaceContent" class="zcontent" align="left">
<div id="2SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class="sshl_f" |<#!#>
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
|- class="odd"
| class=" " | Row1
| class="sshl_f" |JOHN SMITH
| class=" " | JOHN SMITH
| class=" " |
|
| class=" " |
|
|- class="even"
|- class="even"
| class=" " | Row2
| class="sshl_f" |123*123
| class="sshl_f" | JO
| class=" " |
|
| class=" " |
|
|- class="odd"
|- class="odd"
| class="sshl_f" |
| class=" " |
| class=" " |
| class="sshl_f" | JOHN SMITH
|
|- class="even"
|
| class=" SelectTD1 SelectTD1 ChangeBGColor" |
|
|}
|}
=LEFTB(A1,4) : Displays first 4 characters in a string from cell A1. Displays '''<#!#''' as the output.
=LEFTB(A2,5) : Displays first 5 characters in a string from cell A2. Displays '''JOHN ''' as the output. Space Character is also counted.
=LEFTB(A2) : Displays first character '''J''' in a string from cell A2 as the output.
=LEFTB(A3,4) : Displays first 4 characters in a string from cell A3. Displays '''123*''' as the output.
=LEFTB("Good Morning",20) :Displays the full text string '''Good Morning''' as the output.
<font color ="Red">Need to give examples with characters/language supporting DBCS </font>
== See Also ==
*[[Manuals/calci/LEFT | LEFT]]
== References ==
[[Image:formatcells.gif]]
|
*[http://en.wikipedia.org/wiki/String_(computer_science) String]