Difference between revisions of "Manuals/calci/LENB"

Latest revision as of 15:10, 13 August 2018

LENB (Text)

where, is a text string whose length is to be determined.
- LENB(), returns the number of characters in a text string.LENB is intended for use with languages that use the double-byte character set (DBCS).

Description

LENB(Text)

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.
$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").

Examples

ABC#DEF
***
1 3.123

=LENB(A1) : Calculates the number of characters in a string referenced to cell A1. 
Displays 7 as the output. Character '#' is also counted.
=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.
=LENB("<!#!>") : Displays 5 as the output.

Need to give examples with characters/language supporting DBCS

References

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+<div style="font-size:30px">'''LENB (Text) '''</div><br/>
+*where, <math>Text</math> is a text string whose length is to be determined.
+**LENB(), returns the number of characters in a text string.LENB is intended for use with languages that use the double-byte character set (DBCS).
-'''LENB'''(Text)
+== Description ==
-where,
+LENB(Text)
-'''Text''' - is the text whose length to find.
+*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>Text</math> can be any string containing characters, numbers, symbols, blank spaces etc.
+*If argument <math>Text</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
-</div>
+== Examples ==
-----
-<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
-</div></div>
-----
-<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">
 {| id="TABLE3" class="SpreadSheet blue"
-|+ Default Calci
 |- 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="odd"
-| Row3
+| class="sshl_f" | ***
-| class="sshl_f  " |
-| class="     " |
 | class=" " |
 | class=" " |
 |- class="even"
-| Row4
+| class="sshl_f" |1 3.123
-| class="sshl_f SelectTD1  SelectTD1 ChangeBGColor" |
-| class=" " |
 | class=" " |
 | class=" " |
 |- class="odd"
-| class=" " | Row5
+| class="sshl_f" |
-| class="                      " |
-| class="     " |
-| class=" " |
-| class=" " |
-|- class="even"
-| Row6
-|
-| class="     " |
 | class=" " |
 | class=" " |
 |}
-{| id="TABLE3_menu"
+ =LENB(A1) : Calculates the number of characters in a string referenced to cell A1. <br>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. <br>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.
-|
+<font color ="Red">Need to give examples with characters/language supporting DBCS </font>
-|
-[[Image:bold.gif]]
+==Related Videos==
-|
-[[Image:italic.gif]]
+{{#ev:youtube|BI1otcs3nJE|280|center|LEN function}}
-|
-[[Image:normal.gif]]
+== See Also ==
-|
-[[Image:underline.gif]]
+*[[Manuals/calci/LEN | LEN]]
-|
-[[Image:border.gif]]
+== References ==
-|
-[[Image:numbers.gif]]
+*[http://en.wikipedia.org/wiki/String_(computer_science) String]
-|
+*[http://en.wikipedia.org/wiki/DBCS Double-byte Character Set]
-[[Image:sort.gif]]
-|
-[[Image:formatcells.gif]]
-|
+*[[Z_API_Functions | List of Main Z Functions]]
-[[Image:graphs.gif]]
-| $
-|}
-</div>
+*[[ Z3 |   Z3 home ]]
-----

Difference between revisions of "Manuals/calci/LENB"

Latest revision as of 15:10, 13 August 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search