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