On 11/7/06, Josh Nathanson <[EMAIL PROTECTED]> wrote: > Hey Rob, > > > True. Does lead you to wonder, though, how they're sneaking in there. > > Folks don't just type in null characters... > > It leads me to wonder allright!! Maybe forms autofill or something?
I wish I had an answer for you. It's gotta be something, but I've never run into the problem. Do the control characters exist within the database or is there a chance that they're being added when retrieved? > > REReplace ( mystring, '[^\x00-\x7f]', '', 'ALL' ) > > Again, it's a pretty broad brush, but it shouldn't be too hard to > > narrow the focus to all non-printing characters. And it's at least a > > little more scalable. > > Cool thanks, I'll try that regex. Do I need the caret at the beginning of > the range though? I'm looking to match and replace the non-printing > characters, not everything except the non-printing characters...or am I > misunderstanding that? That is a hex representation of the ascii range. I used that regex for something I was working on a while back. You'd need to tweak it out for control/non-printing characters. I don't know the values off the top of my head, but a good ascii table can be found at http://www.subterrane.com/files/asciitable. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259565 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4