Different Use for Word Counts

[#1]

Hi. I have a comment field and I need to count the words in the field for each record and enter the count in an adjacent new field in the table named comment_wordcount. My search for something like this returns answers I do not want (such as frequency count of specific words, split comment into separate words and count each word).

But what I need is, for example, if I have 2 records, each with the comment field, and the comment for record # 1 is "My dog is 8 and has black and brown short hair." the new field comment_wordcount I create for this table would show the value 11; whereas for record #2 the comment "My black cat likes to bite."  would show the value 6 in the new comment_wordcount field.

Any ideas? Even if you suggest counting the spaces, I would be appreciative. Thanks in advance.

Coleman

[jonathandienst · Accepted solution]

Hi

Use substringcount like:

=SubstringCount(Comment, ' ')+1

HTH

Jonathan

[simenkg]

How about something simple like:

SubStringCount(Text,' ')+1

?

[#4]

Thank you.