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

Категории