Re: Control Characters - How to find and convert to spaces

get into sqlplus and type
help translate

NeedaHoliday wrote:
: Can someone help me. Is there an easy way to translate control
: characters to spaces. I have a freeform text field that sometimes
: contains control characters such as line feeds and carriage returns
: (and whatever the user enters). When printing using PRO*C, the CC
: cause major problems. I want to replace them with spaces. Is there
: an easy solution.

: Thanks in advance.
:

--
While Alcatel may claim ownership of all my ideas (on or off the job),
Alcatel does not claim any responsibility for them. Warranty expired when u
opened this article and I will not be responsible for its contents or use.