Reference > Functions reference > Text functions > LeftValues
 
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
Sophie
Bill
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas