QUE CORPORATION - Using Filemaker pro X

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.