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

From: John Clarke <>
Date: Tue, 3 Nov 1998 22:07:09 -0500
Message-ID: <71og3u$>

Use replace --
something like

replace(field, chr(12),' ')

NeedaHoliday wrote in message <>...
>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.
Received on Wed Nov 04 1998 - 04:07:09 CET

Original text of this message