LeftValues

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

Format 

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 

For a description of a list of values, see ValueCount function.

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

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas