Re: Substituting characters in a string

["Jeff T. Orwick [C]" <orwick@CIG.MOT.COM>]

Look at the function TRANSLATE  and the command ENCODE.

ENCODE allows you to define a variable with control characters
TRANSLATE converts all instences of x into y.

On Aug 19,  3:29pm, Bill Spence wrote:
> Subject: Substituting characters in a string
>      I am reading text which contains carriage control
>      characters. Is there a way to edit them out using something
>      like 'substr' so that I can reconfigure the output. The
>      datatype being read is defined as 'long' in an Oracle
>      database.
>
>      Any suggestions  appreciated.
>-- End of excerpt from Bill Spence



--
 Thanks,

Jeff Orwick

847.632.6943