Hi Gurus,I am using ASP 3.0 and I run the following script which I found via Google to delete any non-ASCII friendly string in my SQL Insert statement.I only want to delete non-SQL Friendly string (not exactly non-ASCII).sqlstr = "~!@#$%^&*()_+-=" & chr(10) & "[]\{}|;':"",./<>?"Set objRegExp = New RegExpobjRegExp.Global = TrueobjRegExp.IgnoreCase = TrueobjRegExp.Pattern = "[^\x20-\x7E]"sqlstr = objRegExp.Replace(sqlstr,"")But I thik it stripped too much, It stripped even the ENTER key the chr(10), which I needed it. How to tweak the Regular Expression?
Regular Expression: Remove nonSQL-Friendly string
Posted - 2012-03-02 : 00:13:38
