I want to replace any carriage returns and lines feeds 'OD0A' and '0A' in
string, with a space. Can this be done with TRANSLATE, if so how do I code
this?
John Dunn
Sefas Innovation Ltd
0117 9154267
www.sefas.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John
Hi,
Why not just use the replace function?
select replace('Line1'||chr(10)||'Line2',chr(10),' ') from dual
select replace(my_string,chr(13)||chr(10),' ') from my_table;
HTH,
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 11/18/2002 7:18 AM, John Dunn [EMAIL PROTECTED] wrote:
I want
select replace(input_val,search_val,replacement_val)
from ...
hth
connor
--- John Dunn [EMAIL PROTECTED] wrote: I want
to replace any carriage returns and lines
feeds 'OD0A' and '0A' in
string, with a space. Can this be done with
TRANSLATE, if so how do I code
this?
John Dunn
Sefas