<div>
<div class="content wysiwyg-content">
I have a input field where I'm using tinymce and say my value is &quot;My product &lt;sup&gt;2&lt;/sup&gt;&quot; ... I'm using...<br />
<br />
REReplaceNoCase(str, &quot;[^0-9a-zA-Z ]&quot;, &quot;&quot;, &quot;ALL&quot;) but when it submits the value to the db I get ... &quot;My product&amp;lt;sup&amp;gt; 2&amp;lt;/sup&amp;gt;&quot;. Expected results would be &quot;My product 2&quot;. <br />
<br />
I know you are probably saying, well why use a rich text editor. I'm wanting to save the stripped out version to another column in the db and the html version to another column.<br />
<br />
Thanks!
</div>
</div>


I have a input field where I'm using tinymce and say my value is "My product <sup>2</sup>" ... I'm using...

REReplaceNoCase(str, "[^0-9a-zA-Z ]", "", "ALL") but when it submits the value to the db I get ... "My product&lt;sup&gt; 2&lt;/sup&gt;". Expected results would be "My product 2". 

I know you are probably saying, well why use a rich text editor. I'm wanting to save the stripped out version to another column in the db and the html version to another column.

Thanks!

How can I strip out special characters and HTML tags, I know this question has been asked a 1000 times on Google but having trouble with those solutions.

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.