Reference > Functions reference > Text functions > LeftValues

LeftValues

Returns values contained in text, according to the specified numberOfValues, counting from the left.

Format

LeftValues(text;numberOfValues)

Parameters

text - any text expression or text field

numberOfValues - any numeric expression or field containing a number

Data type returned

text

Originated in

FileMaker Pro 7.0

Description

Values are text items separated by carriage returns. 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.

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

Example 1

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

Plaid
Canvas

Example 2

LeftValues ( list ; 1 ) returns

Sophie

when the text being evaluated contains

Sophie
Bill