Remove Special Charachters \n\r CR LF from data PL / SQL Oracle and .Net
In ORACLE SELECT REPLACE(REPLACE(YourColumn,CHAR(13),NULL),CHAR(10),NULL) FROM YourTable FOR ONE CHAR : SELECT replace(YourColumn,CHAR(13),”) FROM YourTable OR update YourTable set YourColumn =replace(YourColumn,CHAR(13),”) IN .NET MyString.Replace(“\r\n”,””) or.. MyString.Replace(“\r\n”,@”\n”) Potential Blacklist Special control chars…
Read more