Count Words in String 3

[dunkyn]

What function may I use to count the number of words in a string?

 

[IdoMillet]

This should do the trick:
---------------------------------
UBOUND(Split({Your_String}, " &quot)
---------------------------------

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dunkyn]

Great! Thank you!

 

[Madawc]

I tried this, and it did work neatly on well-edited text. But for more messy input, it counted excess embedded spaces as 'words' - separate items, presumably. Madawc Williams
East Anglia
Great Britain

 

[dunkyn]

Madawc

Solution -

I had the same problem, but solved it with enclosing the formula with Trim(). Works wonderfully!

 

[IdoMillet]

TRIM() may solve leading or trailing spaces, but would not solve cases where there is more than one space between the words.

To solve cases where there are double spaces within the string, use:
------------------------------------------------
UBOUND(Split(REPLACE({Your_String}," "," &quot, " &quot)
------------------------------------------------
This starts by replacing any double space within the string by a single space.

Cheers,
- Ido


CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dunkyn]

Great idea. You must have encountered this once upon a time.

Thanks for the input!