Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find and replace special characters

user13115886Dec 16 2016 — edited Dec 17 2016

Hi,

By using regexp_like and regexp_replace, how to find non printable characters from a string.

Column1

000000000#

€˜0051400

would like to remove # and € and all special characters which are of €, which are not readable by the keyboard.

select * from table1 where REGEXP_LIKE(column1, '[^A-Z^a-z^0-9^[^.^{^}]' ,'x');

please advise.

Thanks

Aman

This post has been answered by chris227 on Dec 16 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2017
Added on Dec 16 2016
4 comments
20,119 views