Re: Control Characters - How to find and convert to spaces
From: John Clarke <jclarke_at_centroidsys.com>
Date: Tue, 3 Nov 1998 22:07:09 -0500
Message-ID: <71og3u$22h1_at_morgan.iocenter.net>
Date: Tue, 3 Nov 1998 22:07:09 -0500
Message-ID: <71og3u$22h1_at_morgan.iocenter.net>
Use replace --
something like
replace(field, chr(12),' ')
NeedaHoliday wrote in message <36388d1d.78905664_at_news.pwgsc.gc.ca>...
>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