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
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