RIGHTB(Text, Number_bytes)

where,

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

RIGHTB() displays the last character or characters from a text string, depending on specified number of bytes.

Description

e.g. RIGHTB("String123",3) displays 123 as a result.

RIGHTB counts 2 bytes per character when system is set to language supporting DBCS, else counts 1 byte per character.
RIGHTB works with the languages that use 'Double Byte Character Set' (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").
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 RIGHTB() function.

<#!#>
JOHN SMITH
123*123

=RIGHTB(A1,4) : Displays last 4 characters in a string from cell A1. Displays #!#> as the output. 
=RIGHTB(A2,6) : Displays last 6 characters in a string from cell A2. Displays  SMITH as the output. 
Space Character is also counted.
=RIGHTB(A3) : Displays last character in a string from cell A3. Displays 3 as the output.
=RIGHTB("Good Morning",20) :Displays the full text string Good Morning as the output.

Need to give examples with characters/language supporting DBCS