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.