More Calculations and Data Types - FileMaker Pro 13: The Missing Manual - page 514

ValueCount ( "Tom Cruise¶Keith Urban" )
NOTE
The value list doesn't need a paragraph symbol after the last value to return the proper count. So if
you're building a return-separated list in order to grab data from it, then don't worry about adding
that last ¶ symbol.
FilterValues() works like its plain cousin Filter() . You specify the text and then the
values you want to allow. For example, the following function returns Nicole and Katie :
FilterValues ( "Mimi¶Nicole¶Katie ; "Katie¶Nicole" )
FileMaker has RightValues() and MiddleValues() functions, too. See the box on When
Data Doesn't Comply for ideas on how to use them.
Text Counting Functions
You can also work with text by counting its individual parts. FileMaker has three related
functions for finding out how much text your fields contain:
▪ The Length() function returns the length of a text value by counting characters.
▪ The WordCount() function tells you how many words are in a text value.
▪ Using the ValueCount() function, you can find out how many lines a field has.