Functions Reference

FILEMAKER FUNCTIONS REFERENCE 244
Originated in
FileMaker Pro 6.0 or earlier
Description
Use the Upper function to ensure consistent data entry of such things as state abbreviations or
postal codes.
Examples
Upper(“Ca”) returns CA.
Upper(“12n34p”) returns 12N34P.
Related topics
Contents
Functions reference (alphabetical list)
ValueCount
Purpose
Returns a count of the total number of values in text.
Format
ValueCount(text)
Parameters
text - any text expression or text field
Important See Design functions for information about literal text parameters.
Data type returned
number
Originated in
FileMaker Pro 7.0
Description
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.