LEFTB(Text, Number_bytes)

where,

Text is a text string containing characters to extract,
Number_bytes represents the number of characters to be extracted.

LEFTB() displays the characters from a text string, depending on specified number of bytes.

Description

e.g. LEFTB("String",2) displays St as a result.

LEFTB counts 2 bytes per character when system is set to language supporting DBCS, else counts 1 byte per character.
LEFTB works with the languages that use 'Double Byte Character Set' (DBCS).
Text can be any string containing characters, numbers, symbols, blankspaces etc.
If argument Text is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
Argument Number_bytes indicates the number of byte characters to be displayed from a text string. Number_bytes should be >0.
If Number_bytes >'length of text', Calci displays the entire text.
If Number_bytes is omitted, Calci assumes it to be 1.

Examples

Consider the following examples as input to LEFTB() function.

<#!#>
JOHN SMITH
123*123

=LEFTB(A1,4) : Displays first 4 characters in a string from cell A1. Displays <#!# as the output. 
=LEFTB(A2,5) : Displays first 5 characters in a string from cell A2. Displays JOHN  as the output. Space Character is also counted.
=LEFTB(A2) : Displays first character J in a string from cell A2 as the output.
=LEFTB(A3,4) : Displays first 4 characters in a string from cell A3. Displays 123* as the output.
=LEFTB("Good Morning",20) :Displays the full text string Good Morning as the output.

Need to give examples with characters/language supporting DBCS