Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual
Product codes
TJ083LL/A
174 FileMaker Functions Reference
numberOfValues - any numeric expression or field containing a number
Important
See chapter 4, “Design functions” for information about literal text parameters.
Data type returned
text
Description
Returns a text result containing the specified numberOfValues from the list of values in
text, counting from the left.
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.
text, counting from the left.
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
Canvas
LeftValues(list;1) returns
Sophie
when the text being evaluated contains
Sophie
Bill
Sophie
Bill
LeftWords
Format
LeftWords(text;numberOfWords)
Parameters
text - any
numberOfWords - any numeric
or field containing a number
Data type returned
text
Description
Returns a text result containing the numberOfWords in text, counting from the left.
Note
The ampersand (&) and hyphen (-) characters identify the beginning of a new word.