Manuals/calci/LENB

LENB(txt)

LENB (Text)

• where, $Text$ 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

Related Videos

LEN function

See Also

• LEN

References

• String
• Double-byte Character Set

• List of Main Z Functions

• Z3 home