[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 RIGHT()
 Return a substring beginning with the rightmost character
------------------------------------------------------------------------------
 Syntax

     RIGHT(<cString>, <nCount>) --> cSubString

 Arguments

     <cString> is the character string from which to extract characters.

     <nCount> is the number of characters to extract.

 Returns

     RIGHT() returns the rightmost <nCount> characters of <cString>.  If
     <nCount> is zero, RIGHT() returns a null string ("").  If <nCount> is
     negative or larger than the length of the character string, RIGHT()
     returns <cString>.  The maximum string size is 65,535 (64K) bytes.

 Description

     RIGHT() is a character function that extracts a substring beginning with
     the rightmost character in <cString>.  It is the same as the character
     expression, SUBSTR(<cString>, <nCount>).  For example, RIGHT("ABC", 1)
     is the same as SUBSTR("ABC", -1).  RIGHT() is related to LEFT(), which
     extracts a substring beginning with the leftmost character in <cString>.

     The RIGHT(), LEFT(), and SUBSTR() functions are often used with both the
     AT() and RAT() functions to locate either the first and/or the last
     position of a substring before extracting it.

 Examples

     .  This example shows the relationship between RIGHT() and
        SUBSTR():

        ? RIGHT("ABCDEF", 3)              // Result: DEF
        ? SUBSTR("ABCDEF", -3)            // Result: DEF

     .  This example extracts a substring from the end of another
        string up to the last occurrence of a comma:

        LOCAL cName := "James,William"
        ? RIGHT(cName,;
        LEN(cName) - RAT(",", cName) - 1)      // Result: William

 Files   Library is EXTEND.LIB.


See Also: RTRIM() STUFF() SUBSTR()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson