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 version 

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