Word Count in a DB

message from malo on 20 Jul 2004
Hi all,

We are trying to do a word count of articles submitted by registered members
of a site. The articles posted to MS Access DB. What can we do to get the total
number of words submitted

thanks
 
RobGT replied to malo on 20 Jul 2004
1. Assign the text to a variable
2. Split that variable into an array
3. Count the length of the array and add 1 to the total to get your word
count

Basic but it would work...
Cheers,
Rob http://robgt.com/
Extensions: http://robgt.com/products/index.asp
Tutorials: http://robgt.com/tutorials/index.asp
Blog: http://blog.robgt.com/
 

Archived message: Word Count in a DB (Macromedia Dreamweaver Web Design)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.