showing only x number of characters

[Joey Martin]

I am using a WYSIWYG editor for articles and the article text is being
inserted into a SQL db field called ARTICLEBODY.

Question:
On my homepage, I only want to display the first 400 characters of
ARTICLEBODY field. I am using the LEN function and it does what I want.
BUT, is there a way to not have it cutoff in the middle of a word?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Ray Costanzo [MVP]]

In your SQL query or using vbscript or jscript in your ASP page? If in your
query, what kind of database? If in your code, what relevant code snippet
are you currently using?

Ray at work
"Joey Martin" <jo**@infosmiths.net> wrote in message
news:ui**************@TK2MSFTNGP15.phx.gbl...

I am using a WYSIWYG editor for articles and the article text is being
inserted into a SQL db field called ARTICLEBODY.

Question:
On my homepage, I only want to display the first 400 characters of
ARTICLEBODY field. I am using the LEN function and it does what I want.
BUT, is there a way to not have it cutoff in the middle of a word?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Evertjan.]

Joey Martin wrote on 09 sep 2004 in
microsoft.public.inetserver.asp.general:

I am using a WYSIWYG editor for articles and the article text is being
inserted into a SQL db field called ARTICLEBODY.

Question:
On my homepage, I only want to display the first 400 characters of
ARTICLEBODY field. I am using the LEN function and it does what I want.
BUT, is there a way to not have it cutoff in the middle of a word?

Sure, many ways.

the nicest ones are in ASP jscript:

t = t.replace(/^(.{0,400}) .*$/,'$1')

or if you do not like regex:

t = t.substr(0,401).split(' ').slice(0,-1).join(' ')

tested, but not tested for exact 400 max

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress,
but let us keep the discussions in the newsgroup)

[Aaron [SQL Server MVP]]

http://www.aspfaq.com/2398

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Joey Martin" <jo**@infosmiths.net> wrote in message
news:ui**************@TK2MSFTNGP15.phx.gbl...

I am using a WYSIWYG editor for articles and the article text is being
inserted into a SQL db field called ARTICLEBODY.

Question:
On my homepage, I only want to display the first 400 characters of
ARTICLEBODY field. I am using the LEN function and it does what I want.
BUT, is there a way to not have it cutoff in the middle of a word?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!