Re: Cleaning stored text to get valid XML

2007-05-05 Thread Les Mizzell
Re; http://www.nelsonmullins.com/rss/rss_newsletters.cfm Finally found a function that seems to clean most of the MS Word control characters and other crap out that was causing me probems. Using two filters on the body text seems to be taking care of my problems now.. cfscript function

Re: Cleaning stored text to get valid XML

2007-05-05 Thread Claude Schneegans
Finally found a function that seems to clean most of the MS Word control characters and other crap out that was causing me probems. Using two filters on the body text seems to be taking care of my problems now.. This will clean only about 1% of the crap, may be not even... Here is a function

Re: Cleaning stored text to get valid XML

2007-05-05 Thread Les Mizzell
This will clean only about 1% of the crap, may be not even... The data in question has been entered using fckeditor, what has taken care of a good bit of the problem stuff for me. It was the few things left over that fck didn't deal with that was giving me fits. I see some great potential

Re: Cleaning stored text to get valid XML

2007-05-04 Thread Robertson-Ravo, Neil (RX)
Have you tried XMLFormat() around the content? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be

Re: Cleaning stored text to get valid XML

2007-05-04 Thread Les Mizzell
Robertson-Ravo, Neil (RX) wrote: Have you tried XMLFormat() around the content? Yup, and the version up now is using it. Still doesn't want to display... http://www.nelsonmullins.com/rss/rss_newsletters.cfm Here's what I've got in there right now: cfset request.bodynohtml =

RE: Cleaning stored text to get valid XML

2007-05-04 Thread Jeremy
If the data is being pasted from word, you will probably need to clean (Replace) the special Microsoft characters that word generates for most of its invisible characters. I know I had problems posting data being pasted from word to my db, and it was those special characters causing the problem.