Remove Special Character

[getjbb]

How can I srip off special characters in PL/SQL?

I have a message which has two small square boxes at the end of it. I do not know what special character these boxes relate to. When I cut and paste them they turn into '?'.

I tried to remove them by using the replace command with chr(13)- replace(message,chr(13),''). The result was that on of the boxes disappeared but the other didn't. They are causing that line in the file to break to the next line.

Sorry I cannot provide you with an example, because when I try to copy the message the boxes disappears and the cursor goes to the next line.

Whatever you can do to help me will be appreciated.

getjbb

 

[carp]

One might also be a CHR(10). They show up together sometimes.

 

[taupirho]

Cant you just grab all but ther last 2 chars

1* select substr('Hello world',1,length('hello world')-2) from dual
SQL> /

SUBSTR('H
---------
Hello wor



In order to understand recursion, you must first understand recursion.

 

[Beilstwh]

Simply use the dump function

select dump(myfield)
from mytable;

This will give a hex dump of the record.

Bill
Lead Application Developer
New York State, USA