LeftWords
Returns text containing the specified numberOfWords in text, counting from the left.
Format
LeftWords ( text ; numberOfWords )
Parameters
text
- any text expression or text field
numberOfWords
- any numeric expression or field containing a number
Data type returned
text
Originated in version
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.