I'm trying to remove few special characters from a comment column in my table. I used the below statement but it seems to remove the
[SYSTEM]:Do you have it in stock? ðŸ˜Š
[SYSTEM]:Do you have it in stock?
My try, I just removed the commas, put the "accepted" characters after the initial "not" and escaped your non alphabetic characters with
A special case are the brackets: http://dba.stackexchange.com/a/109294/6228
select REGEXP_REPLACE( '[ION] are varză murată.', '[^][a-zA-Z0-9[:space:]&:/,.?!]+', ' ') from dual; Result: [ION] are varz murat .