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