writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − − + − + − +
no edit summary
=LENB(txt)=
=LENB(txt)=
<div style="font-size:30px">'''LENB (Text) '''</div><br/>
*where, <math>txt</math> is a text string whose length is to be determined.
*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() returns the number of bytes used to represent characters in a text string.
== Description ==
== Description ==
LENB(txt)
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>txt</math> can be any string containing characters, numbers, symbols, blank spaces etc.
*<math>Text</math> can be any string containing characters, numbers, symbols, blank spaces etc.
*If argument <math>txt</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
*If argument <math>Text</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
== Examples ==
== Examples ==