Category: Text

Syntax: ValueCount ( text )


textAny return-delimited string or expression that generates a return-delimited list.

Data type returned: Number


Returns a count of the number of values in the text provided.

The presence or absence of a trailing return after the last item in the return-delimited list does not affect the result returned by ValueCount. For instance, ValueCount ("Blue¶Green") and ValueCount ("Blue¶Green¶") both return 2.

If there are multiple returns at any point in the list, the ValueCount() function recognizes the empty items as valid items. For instance, ValueCount ("¶¶Blue¶¶Green¶¶") returns 6. Note that this behavior is different from how the WordCount() function treats multiple delimiters. There, multiple delimiters in a row are considered to be a single delimiter.




ValueCount ("A¶B¶C¶D¶E")

Returns 5.

ValueCount (officeList)

Returns 3 when officeList is equal to






San Francisco

: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352 © 2008-2020.
If you may any questions please contact us: