How to remove special UNICODE characters like ñ
710006Jul 30 2009 — edited Sep 24 2009Hi all,
In my RDF file, i should accomidate it in such a way that what ever currupt characters (Especially UNICODE symbols) comes in between the email_address , it has to change to its subsequent character like this...
The output of ñ should be n. This is a kind of example..
When the input value is 'john.muñoz@yahoo.com' it should return to 'john.munoz@yahoo.com'
I have tried using the following functions but the output still shows me the same ..
select UNISTR('john.muñoz@yahoo.com') from dual
Select translate(trim(email_address),'1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ WE8ISO8859P1 ~!#$%^&*()_+}{":?><`=]['''';/,','1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ') from per_people_f
where employee_number = 3951
select CONVERT('john.muñoz@yahoo.com','US7ASCII') from dual
select regexp_replace('john.muñoz@yahoo.com', '[^-.@,a-z,A-Z,[:space:]from dual;
If you have any ideas.. please let me know...
Thanks in advance
Ravi.
Edited by: rkpinus on Jul 30, 2009 8:14 AM