Functions Reference

184 FileMaker Functions Reference
Examples
Upper(“Ca”) returns CA.
Upper(“12n34p”) returns 12N34P.
ValueCount
Format
ValueCount(text)
Parameter
text - any text expression or text field
Important See Design functions, page 35 for information about literal text parameters.
Data type returned
number
Description
Returns a count of the total number of values in text.
Values are text items separated by carriage returns. You can place several items together
to create a carriage-return-delimited list of values. 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.
When the text parameter is a literal string as in the example below, you must insert a
literal carriage return character between each item in the list. In the Specify Calculation
dialog box, click the ¶ button to insert a literal carriage return character.
Examples
ValueCount(“Item 1¶Item 2¶Item 3”) returns 3.
ValueCount(ValueListItems(“Employees”;“Employee Names”) returns the
total number of values in the Employee Names value list in the Employees database file.
WordCount
Format
WordCount(text)
Parameter
text - any text expression
or text field
Data type returned
number