This is the query to solve the problem, it use regexp functions
select regexp_replace('This is a test $%&^*&*'||chr(10)||'*"ú%bsfd.', '( *[[:punct:]])', '') from dual
I really like how regexp functions can do, for more information, check more from here: http://psoug.org/reference/regexp.html
No comments:
Post a Comment