ValueCount()

 <  Day Day Up  >  

ValueCount()

Category: Text

Syntax: ValueCount (text)

Parameters: text ”any return-delimited string or expression that generates a return-delimited list.

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

Examples:

 

 ValueCount ("ABCDE") 

Returns 5 .

 

 ValueCount (officeList) 

Returns 3 when officeList is equal to

Atlanta

Chicago

San Francisco

Comments:

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 .

 <  Day Day Up  >  


QUE CORPORATION - Using Filemaker pro X
QUE CORPORATION - Using Filemaker pro X
ISBN: N/A
EAN: N/A
Year: 2003
Pages: 494

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net