RIGHTB
Syntax:
RIGHTB ( string , [ number-bytes ] )
Description: Extracts the right-most number-bytes-worth of characters from string. (RIGHTB
is intended for use with languages that use the double-byte character set (DBCS), whereas RIGHT
(§3.17.7.272) is intended for use with languages that use the single-byte character set (SBCS).)
Arguments:
Name |
Type |
Description |
---|---|---|
string |
text |
Designate the string from which a substring is to be extracted. |
number-bytes |
number |
The number of bytes to be extracted. If omitted, a count of 1 shall be assumed. number-bytes shall be at least 0. If number-bytes exceeds the length of string, the whole of string shall be extracted. |
Return Type and Value: text – A string containing the right-most number-bytes-worth of characters from string.
However, if number-bytes < 0, #VALUE!
is returned.