Functions Reference

FILEMAKER FUNCTIONS REFERENCE 209
Examples
Left(“Manufacturing”;4) returns Manu.
Left(Name;Position(Name;“ “;1;1)) returns Sophie, when the Name field contains Sophie
Tang .
Left(PostalCode;3) & Upper(Left(LastName;4)) returns 481JOHN when the
PostalCode field contains 48187 and LastName contains Johnson.
Related topics
Contents
Functions reference (alphabetical list)
LeftValues
Purpose
Returns a text result containing numberOfValues from the list of values in text, 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