LeftValues
 
Purpose 
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
Important  See Design functions for information about literal text parameters.
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.
Examples 
LeftValues(“Plaid¶Canvas¶Suitcase”;2) returns
Plaid
Canvas
LeftValues(list;1) returns
Sophie
when the text being evaluated contains
 •
 •
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas