Skip to Main Content
Forums

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!

function to remove non alphabet(english letters) characters.

rajasekhar_nMar 31 2009 — edited Mar 31 2009
Hi All,


Is there any function to replace other than alphabets(english letters).
                   In java there is a function like : String s="L AMÉRIQUE C EST ÇA";
                         
                         s=s.replaceAll("[^a-zA-Z0-9 ]", "");

                      This function removes all  other than (a-zA-Z0-9 ) this characters.
            
                        Result: L AMRIQUE C EST A
Please let me know is there any function available in oracle.


Regards,
Rajasekhar
This post has been answered by Hoek on Mar 31 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2009
Added on Mar 31 2009
11 comments
1,231 views