RightValues()

RightValues()

Category: Text

Syntax: RightValues (textToFilter ; numberOfValues)

Parameters: textToFilter ”any return-delimited text string or expression that generates a return-delimited string; numberOfValues ”any positive number or expression that returns a positive number.

Description: Returns the specified number of items from the end of the textToFilter parameter.

Examples:

 RightValues("ABCDE";3) 

Returns the following:

 C D E RightValues(test;1) 

Returns C when test contains

 A B C 

Comments:

The RightValues() function returns the last n items from a return-delimited array. The items themselves will be a return-delimited array, and there will always be a trailing return at the end of the last item.

See the LeftValues() function for a discussion of methods to remove the trailing return from the output of the RightValues() function.