ZCubes Wiki

Changes

Manuals/calci/LENB (view source)

Revision as of 15:40, 13 January 2014

823 bytes removed ,  15:40, 13 January 2014
no edit summary
Line 1: Line 1: −
<div id="6SpaceContent" class="zcontent" align="left">
+
=LENB(txt)=
   −
'''LENB'''(Text)
+
*where, <math>txt</math> is a text string whose length is to be determined.
   −
where,
+
LENB() returns the number of bytes used to represent characters in a text string.
   −
'''Text''' - is the text whose length to find.
+
== Description ==
   −
</div>
+
LENB(txt)
−
----
  −
<div id="1SpaceContent" class="zcontent" align="left">LENB returns the number of bytes used to represent the characters in a text string.LENB is intended for use with languages that use the double-byte character set (DBCS). </div>
  −
----
  −
<div id="7SpaceContent" class="zcontent" align="left"></div>
  −
----
  −
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
     −
LENB
+
*LENB() counts 2 byte per character when default language is set as Double-byte Character Set (DBCS). Else LENB() counts 1 byte per character similar to LEN.
 +
*Languages such as Japanese, Chinese, Korean etc support DBCS.
 +
*<math>txt</math> can be any string containing characters, numbers, symbols, blankspaces etc.
 +
*If argument <math>txt</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
   −
</div></div>
+
== Examples ==
−
----
  −
<div id="8SpaceContent" class="zcontent" align="left">
     −
Lets see an example in (Column1, Row2)
  −
  −
<nowiki>=LENB(R1C1)</nowiki>
  −
  −
LENB returns 10.
  −
  −
</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">
 
<div id="2SpaceContent" class="zcontent" align="left">
    
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
−
|+ Default Calci
   
|- class="even"
 
|- class="even"
−
| class=" " |
+
| class="sshl_f" |ABC#DEF
−
| Column1
  −
| Column2
  −
| Column3
  −
| Column4
  −
|- class="odd"
  −
| class=" " | Row1
  −
| JOHN SMITH
  −
| class="                                                      " |
  −
| class=" " |
  −
| class=" " |
  −
|- class="even"
  −
| class="  " | Row2
  −
| class="sshl_f" | 10
  −
| class=" " |
   
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
 +
 
|- class="odd"
 
|- class="odd"
−
| Row3
+
| class="sshl_f" |
−
| class="sshl_f " |
  −
| class="    " |
   
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
 +
 
|- class="even"
 
|- class="even"
−
| Row4
+
| class="sshl_f" |1 3.123
−
| class="sshl_f SelectTD1  SelectTD1 ChangeBGColor" |
  −
| class=" " |
   
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
 +
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row5
+
| class="sshl_f" |  
−
| class="                      " |
  −
| class="    " |
  −
| class=" " |
  −
| class=" " |
  −
|- class="even"
  −
| Row6
  −
|
  −
| class="    " |
   
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
|}
 
|}
   −
{| id="TABLE3_menu"
+
=LENB(A1) : Calculates the number of characters in a string referenced to cell A1. Displays '''7''' as the output. Character '#' is also counted.
−
| align="right" | TABLE3
+
=LENB(A3) : Calculates the number of characters in a string referenced to cell A3. Displays '''7''' as the output. Space and decimal point are also counted.
−
| <span align="left">[[Image:calci1.gif]]</span>
+
=LENB("<!#!>") : Displays '''5''' as the output.
−
|
+
 
−
|
+
== See Also ==
−
[[Image:bold.gif]]
+
 
−
|
+
*[[Manuals/calci/LEN | LEN]]
−
[[Image:italic.gif]]
+
 
−
|
+
== References ==
−
[[Image:normal.gif]]
  −
|
  −
[[Image:underline.gif]]
  −
|
  −
[[Image:border.gif]]
  −
|
  −
[[Image:numbers.gif]]
  −
|
  −
[[Image:sort.gif]]
  −
|
  −
[[Image:formatcells.gif]]
  −
|
  −
[[Image:graphs.gif]]
  −
| $
  −
|}
     −
</div>
+
*[http://en.wikipedia.org/wiki/String_(computer_science) String]
−
----
+
*[http://en.wikipedia.org/wiki/DBCS Double-byte Character Set]
Swapna
writer
2,661

edits

Retrieved from "http://wiki.zcubes.com/Special:MobileDiff/197196"