Calculating Word Count

[Former Member]

Hello,

Does anyone know a formula for calculating word count pulled from a specific text column from a SQL database into crystal?

Thanks.

[Former Member · Accepted solution]

You could do this.

Len("Text String")

Returns 11. The blank space between "Text" and "String" is counted as a character.

so len () / 5 will give you a guestimate of the number of words (this would count spaces also) if you dont want the spaces, you will need to remove them and then divide the new length by 5 ( 5 is the average word length in most cases)