All Forums Database
ritwikdey2809 1 post Joined 04/13
24 Apr 2013
Handling Special Characters

I have a table which has a column where I can find special characters like &Altide; &Abc; etc. The total list of special characters is 110, I identified them using the logic anything between "&" and ";" is a special character and finally cross checked manually. Now I need to find and replace them in my table with space(" ").
Say the record is "ABCD123 &Altide; EFGH &ACB; &123; 123" then the record should be like "ABCD EFGH 123". To do this I have 2 problems 1st: The records which have "ABCD & this is not supposed to be a special character, putting semi colon just like that;" will loose the info between "&" and ";". This is more of business problem and I am trying to get an alternative for this by putting some logic.
2nd and the more severe problem is even if I identify the list of special characters I need to find out each and every special character or maybe put the logic of "&" and ";" and traverse each and every row of my table at each data load and replace it with space. This is highly resource consuming and must have an alternative.
Any leads to an alternative?

Copy paste never works!!!! Smart work does..
You must sign in to leave a comment.