A recent project has a need for a regular expression in an Oracle database that requires a non-Chinese character other than a number or letter
Replace all characters except letters, numbers, kanji with null if you have the following fields
' Asdfsad,,; ' ()!@123234#$%^&* (i w is e-Chinese .../\[]:: "" one person "
Finally get the value: asdfsad123234 I am a Chinese person
Select Fn_reg_replaceother (' Asdfsad,,;) ()!@#$%^&* (I am?) Chinese .../\[]:: ' "one person, ' regular expression Required, '" from dual;
Thank you. The following answers should not be posted:
(\s) | (\,)| (\,) | (\.)| (\。 )| (\:)| (\:) | (\;) | (\;)| (\)) | (\)) | (\ () | (\))| (\()| (\ ') | (\')| (\'')| (\")| (\ ") | (\ ") | (\[)| (\]| (\!)| (\! )| (\@)| (\#)| (\%)| (\%)| (\^)| (\&) | (\*)| (\¥) | (\$)| (\/)| (\\)| (\?)| (\? ))
------Solution--------------------
Select Regexp_replace (' Asdfsad,,;) ()!@123234#$%^&* (i w is e-Chinese .../\[]:: "" one person "
, ' [[:p unct:]| [: blank:]| [: space:]| [: Cntrl:]] ', '
From dual
;
Regexp_replace (' Asdfsad,,;)
-----------------------------
asdfsad123234 i W is e Chinese one person
Well, this article is the end of the content, hope to be useful to everyone.