The only problem with this is that it will cut it off in mid-word. So, you can just loop from 1000 down to 1 and check for the end of a word/parag raph, and when it is found, take that index to do the Left().
>>> "Jim Curran" <[EMAIL PROTECTED]> 02/21/02 02:08PM >>> For the blurb area try this... First choose a character count for the words (fairly easy method, and since you specify 100 - 200 words, I'll assume it's flexible) Lets say 1000 chars #left(body,find(" ",body,1000))# What this does is find the first space after char position 1000 and trims at that point. Add a ... < more > link to the full article and you're set - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -----Original Message----- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 5:14 PM To: CF-Talk Subject: How to trim text (read inside) I have a database table that contains news headlines. I was wondering how to be able to take like the first 100 - 200 words of the news story and display it in a "introduction" like section. What I want is that when people come to the site, they see the latest headlines with the headline, the date and a brief blurb from it as well as the link to read the rest. Any help would be appreciated. ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists