RightValues()

Category: Text

Syntax: RightValues ( text; numberOfValues )

Parameters:

textAny return-delimited text string or expression that generates a return-delimited string.

numberOfValuesAny positive number or expression that returns a positive number.

Data type returned: Text

Description:

Returns the specified number of items from the end of the text parameter.

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.

Examples:

Function	Results
RightValues("A¶B¶C¶D¶E";3)	Returns the following:
	C
	D
	E
RightValues(test;1)	Returns C when test contains
	A
	B
	C