LeftWords

Returns text containing the specified numberOfWords in text, counting from the left.

Format 

Parameters 

text - any text expression or text field

numberOfWords - any numeric expression or field containing a number

Data type returned 

text

Originated in 

FileMaker Pro 6.0 or earlier

Example 1 

LeftWords ( "Plaid Canvas Suitcase" ; 2 ) returns Plaid Canvas.

Example 2 

LeftWords ( Name ; 1 ) returns Sophie, when the Name field contains Sophie Tang.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

WordCount function