Home » SQL & PL/SQL » SQL & PL/SQL » Filter Special Characters
Filter Special Characters [message #574308] Tue, 08 January 2013 21:53 Go to next message
Thriller
Messages: 5
Registered: January 2013
Junior Member
Hello Guys,
This is my first post in orafaq.com
I have an issue.
I have one column name party_name containing Korean Characters and English characters.
Some of the English characters have different symbols.
My requirement is to get the data and exclude those symbols but not Korean characters.
Already I used a function to replace special symbols with space.
The function contains code based on ASCII values it works good but it filters Korean characters too.
Please find the attachment of the screenshot,
When I double click the name it shows with some question mark.

./fa/10588/0/

Anyone please help me out with this issue.


Thanks.
  • Attachment: e.jpg
    (Size: 10.58KB, Downloaded 376 times)
Re: Filter Special Characters [message #574310 is a reply to message #574308] Tue, 08 January 2013 22:20 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>Some of the English characters have different symbols.

Do you expect us to guess which characters are "different"?
Different from what?

>My requirement is to get the data and exclude those symbols but not Korean characters.
While you may have clarity regarding "those symbols", I don't know which should be kept & which should be discarded.

[Updated on: Tue, 08 January 2013 22:40]

Report message to a moderator

Re: Filter Special Characters [message #574312 is a reply to message #574310] Tue, 08 January 2013 22:42 Go to previous messageGo to next message
Thriller
Messages: 5
Registered: January 2013
Junior Member
Di you check the attachment?
Re: Filter Special Characters [message #574315 is a reply to message #574312] Tue, 08 January 2013 23:04 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
Did you read the Posting Guidelines?
Re: Filter Special Characters [message #574318 is a reply to message #574315] Tue, 08 January 2013 23:56 Go to previous messageGo to next message
Thriller
Messages: 5
Registered: January 2013
Junior Member
Ok,

I am looking for a SQL query which checks for special character(s) in a string and replace them with space

My input will be like this

OFFICER DISTRIBUIDORA DE PRODUTOS DE INFORM�ICA
4073 - OFFICER�DISTRIB
PAUTA DISTRIBU�O E LOGISTICA SA


The Output should be like

OFFICER DISTRIBUIDORA DE PRODUTOS DE INFORM ICA
4073 - OFFICER DISTRIB
PAUTA DISTRIBU O E LOGISTICA SA

It means replacing the symbols with space.

Thanks
Re: Filter Special Characters [message #574320 is a reply to message #574318] Wed, 09 January 2013 00:01 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
>I am looking for a SQL query which checks for special character(s) in a string and replace them with space
post SQL that SELECT only "special" characters.

Re: Filter Special Characters [message #574321 is a reply to message #574320] Wed, 09 January 2013 00:30 Go to previous messageGo to next message
Thriller
Messages: 5
Registered: January 2013
Junior Member
select * from hz_parties where party_name like '%OFFICER DISTRIBUIDORA DE PRODUTOS DE%'

PARTY_ID   PARTY_NUMBER  PARTY_NAME
535534	   345655	 OFFICER DISTRIBUIDORA DE PRODUTOS DE INFORM�ICA
567567	   345555	 OFFICER DISTRIBUIDORA DE PRODUTOS DE INFORM�ICA	

[Updated on: Wed, 09 January 2013 00:33]

Report message to a moderator

Re: Filter Special Characters [message #574328 is a reply to message #574321] Wed, 09 January 2013 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 59154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use DUMP function to see what is in the database:
select dump(PARTY_NAME) from hz_parties where party_name like '%OFFICER DISTRIBUIDORA DE PRODUTOS DE%';


Regards
Michel
Re: Filter Special Characters [message #574402 is a reply to message #574328] Thu, 10 January 2013 00:43 Go to previous messageGo to next message
Thriller
Messages: 5
Registered: January 2013
Junior Member
No use
They are unrecognized characters
Re: Filter Special Characters [message #574407 is a reply to message #574402] Thu, 10 January 2013 01:34 Go to previous message
Michel Cadot
Messages: 59154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What does this mean? You have bad data in your database?

Regards
Michel
Previous Topic: SQL%ROWCOUNT USing in INSERT or update trigger
Next Topic: Generic application error
Goto Forum:
  


Current Time: Mon Sep 22 05:50:18 CDT 2014

Total time taken to generate the page: 0.28636 seconds