Reference > Functions reference > Text functions > WordCount
 

WordCount

Returns a count of the total number of words in specified text.

Format 

WordCount ( text )

Parameters 

text - any text expression or text field

Data type returned 

number

Originated in 

FileMaker Pro 6.0 or earlier

Notes 

In addition to space, tab, enter, and carriage return characters, characters such as equal (=), ampersand (&), hyphen (-), and so on identify the beginning of a new word. For more information about word separators, search the FileMaker Knowledge Base.

Example 1 

WordCount ( "The sun is rising." ) returns 4.

Example 2 

WordCount ( Letter ) returns the total number of words in the Letter field. If the Letter field contains the text x=y=1.5, this example returns 3 because each equal (=) character identifies the beginning of a new word.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas