RightValues function

Contents > Functions reference (alphabetical list) > Text functions > RightValues function

RightValues function

Format


RightValues(text;numberOfValues)

Parameters

text - any text expression or text field

numberOfValues - any numeric expression or field containing a number

Important See Design functions for information about literal text parameters.

Data type returned

text

Description

Returns a text result containing the specified numberOfValues in text starting from the right.

Values are text items separated by carriage returns. You can place several items together to create a carriage return-delimited list of values. A value can be empty, a single character, a word, a sentence, or a paragraph. When you press Return you start creating a new value. The last value will be recognized with or without a carriage return.

When the text parameter is a literal string as in the example below, you must insert a literal carriage return character between each item in the list. In the Specify Calculation dialog box, click the ¶ button to insert a literal carriage return character.

Each value that is returned ends with a carriage return, allowing lists to be easily concatenated.

Examples

RightValues("Plaid¶Canvas¶Suitcase";2) returns

Canvas

Suitcase

RightValues(names;1) returns

John

when the names field contains

Sophie

Bill

John

Related topics

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

Contents > Functions reference (alphabetical list) > Text functions > RightValues function