When and how to trim string

Forum|Forum|16 years ago
May 27, 2009
1 reply
1032 views

Not sure the best way around this issue. In a query I have the following:

SUBSTRING(blogStories.blogBody,1,220) AS blogBody

Later, when I go to display this, I want to strip the html so I have this:

<cfoutput>#trimmedBodyText#</cfoutput> ... (more)

This is where the problem comes in. If my SQL query happens to end in the middle of a string like this:

Web 2.0 tools allow opportunities for doing traditional things in new and fundamentally different ways. As Clay Shirky writes in <a target="_blank" href="http://perma://BLPageReference/75484FCE-115D-450B-A2DF-4F71745B

Then the REReplaceNoCase causes problems because there is no end tag.

Can I do this in SQL, or should I pull the whole story, do the REReplaceNoCase and then trim it? If so, what is the command in ColdFusion for trimming? Everything I've found only trims spaces. I can't seem to specify a length anywhere.

Database access

This topic has been closed for replies.

L

Lee CrockettAuthor

Known Participant

OK, I hadn't received an answer and I kept digging and found the LEFT command, so what I have done is changed my query to get the entire story then I run this code for the output

#variables.blogStory#... (more)</td>

Then the problem was that sometimes I'd get cut off in the middle of a word, so I've changed it to this to find the last word and remove it:

#variables.blogStory#... (more)</td>

This solves the problem for me. I get the output I want, but I'm sure there is a more elegant way of doing this with less code. If anyone knows of one, I'd love to hear it.