Regular expressions for non-Chinese characters except numbers and letters in ORACLE database

This article introduces the knowledge of "finding regular expressions of non-Chinese characters except numbers and letters in ORACLE database". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Recently, there is a need for regular expressions of non-Chinese characters other than numbers and letters in the ORACLE database.

If you have the following fields, you need to replace all characters except letters, numbers and Chinese characters with blanks.

'asdfsad,;) ()! @ 123234% ^ & * (I am e? Chinese. /\ []::' "one person''

Finally get the value: asdfsad123234, I am a Chinese.

Select FN_REG_REPLACEOTHER ('asdfsad,;) ()! @ # $% ^ & * (I am Chinese.. /\ []::' one person', 'needed regular expression,') from dual

Thank you. Do not follow the following answers:

(\ s) | (\,) | (\,) | (\.) | (\.) | | (\:) | (\:) | (\;) | (\;) | (\) | (\') | (\ ") | (\ [) | (\]) | (\!) | (\!) | | (\ @) | (\%) | (\ ^) | (\ &) | (\ *) | (\ ¥) | (\ $) | (\ /) | (\) | (\?) | (\?)) |

-solution-

Select regexp_replace ('asdfsad,;) ()! @ 123234% ^ & * (I am e? Chinese. /\ []::' 'one person'

,'[: punct:] | [: blank:] | [: space:] | [: cntrl:]]','')

From dual

REGEXP_REPLACE ('ASDFSAD,;)

-

Asdfsad123234, I am a Chinese.

This is the end of the content of "regular expressions for non-Chinese characters except numbers and letters in ORACLE database". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!