Archives January 2015

Business Consulting: Tailored strategies to enhance your business performance.
Financial Planning: Comprehensive plans to secure your financial future.
Market Analysis: In-depth insights to keep you ahead of market trends.
Project Management: Efficient solutions to ensure your projects succeed.
Training & Development: Programs designed to boost your team's skills and productivity.

Jan, Mon, 2015
Kaidanov
0

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…

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…