RIGHTB

Returns the last character or characters of a text with double bytes characters sets (DBCS).

tip

This function is available since LibreOffice 4.2.


āϏāĻŋāύāĻŸā§āϝāĻžāĻ•ā§āϏ

RIGHTB("Text" [; Number_bytes])

āĻĒāĻžāĻ ā§āϝ āĻšāϞ⧋ āĻĒāĻžāĻ ā§āϝ āϝāĻžāϰ āϏāĻ āĻŋāĻ• āĻ…āĻ‚āĻļāϟāĻŋ āύāĻŋāĻ°ā§āϧāĻžāϰāĻŖ āĻ•āϰāĻž āĻšāĻŦ⧇āĨ¤

Number_bytes (optional) specifies the number of characters you want RIGHTB to extract, based on bytes. If this parameter is not defined, one byte is returned.

āωāĻĻāĻžāĻšāϰāĻŖ

RIGHTB("中å›Ŋ";1) returns " " (1 byte is only half a DBCS character and a space character is returned instead).

RIGHTB("中å›Ŋ";2) returns "å›Ŋ" (2 bytes constitute one complete DBCS character).

RIGHTB("中å›Ŋ";3) returns " å›Ŋ" (3 bytes constitute one half DBCS character and one whole DBCS character; a space is returned for the first half).

RIGHTB("中å›Ŋ";4) returns "中å›Ŋ" (4 bytes constitute two complete DBCS characters).

RIGHTB("office";3) returns "ice" (3 non-DBCS characters each consisting of 1 byte).

Please support us!