text - any text expression or text field

numberOfValues - any numeric expression or field containing a number

text

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.

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

RightValues(names;1) returns

when the names field contains

Sophie
Bill
John