Difference between revisions of "Manuals/calci/LENB"
Jump to navigation
Jump to search
| (3 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =LENB( | + | <div style="font-size:30px">'''LENB (Text) '''</div><br/> |
| − | + | *where, <math>Text</math> is a text string whose length is to be determined. | |
| − | *where, <math> | + | **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() returns the number of | ||
== Description == | == Description == | ||
| − | LENB( | + | 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. | *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. | *Languages such as Japanese, Chinese, Korean etc support DBCS. | ||
| − | *<math> | + | *<math>Text</math> can be any string containing characters, numbers, symbols, blank spaces etc. |
| − | *If argument <math> | + | *If argument <math>Text</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name"). |
== Examples == | == Examples == | ||
| Line 40: | Line 38: | ||
|} | |} | ||
| − | =LENB(A1) : Calculates the number of characters in a string referenced to cell A1. Displays '''7''' as the output. Character '#' is also counted. | + | =LENB(A1) : Calculates the number of characters in a string referenced to cell A1. <br>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(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. |
=LENB("<!#!>") : Displays '''5''' as the output. | =LENB("<!#!>") : Displays '''5''' as the output. | ||
<font color ="Red">Need to give examples with characters/language supporting DBCS </font> | <font color ="Red">Need to give examples with characters/language supporting DBCS </font> | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|BI1otcs3nJE|280|center|LEN function}} | ||
== See Also == | == See Also == | ||
| Line 53: | Line 55: | ||
*[http://en.wikipedia.org/wiki/String_(computer_science) String] | *[http://en.wikipedia.org/wiki/String_(computer_science) String] | ||
*[http://en.wikipedia.org/wiki/DBCS Double-byte Character Set] | *[http://en.wikipedia.org/wiki/DBCS Double-byte Character Set] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 16: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).
is a text string whose length is to be determined.
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.
- can be any string containing characters, numbers, symbols, blank spaces etc.
- If argument 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
Related Videos
See Also
References