Will, > > I have a page which enters details via an array into a DB. At the > moment, some of the items in the array contain ASCII characters which I > need to convert to their proper "symbols." For example: > > James' fear of spiders > > I presume this should read "James' fear of spiders." I'd like to > convert the string before entering into the DB, but would also like to > fix the current table (contains about 20,000 of which about half have > these ASCII characters). >
If you're only displaying the text on a web page, you needn't go to the trouble of hacking the HTML escape codes out. Otherwise, you need to look at regex to find and replace &#xx; with CHR(xx) if thats really what you want to do. Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
