A couple of options: Loop over the text using find() or findnocase(). More code, may be faster.
Use refind() or refindnocase() to find all the matches (return an array of them) and then get the arraylen() of what it returns. Easier code, but it will likely run slower. --Ben Doom Web Exp wrote: > Hi. I have a large chunk of text/html-text in the database and I need > to find out the number of times the term "fantabulous" occurs in it. > Any CF function/UDFs that I can use? > > Any ideas please? > > Thanks, > k > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292543 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
