Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual
Product codes
TJ083LL/A
Chapter 12
|
Text functions 189
Description
Returns all letters in text as uppercase. 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
.
ValueCount
Format
ValueCount(text)
Parameter
text - any
Important
See chapter 4, “Design functions” 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
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.
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
WordCount
Format
WordCount(text)