How To Remove The Carriage Return (CR) Characters From SQL*Plus Spooled Output On Windows (Doc ID 1638278.1)

Last updated on APRIL 23, 2020

Applies to:

Goal

You find special characters <CR><LF> [carriage-return + line feed] at the end of each record in a normal output from a SQL*Plus spooled file.
Need a way to filter out <CR> and select only <LF>. 

For example:

Spooled output looks like this:

10 ACCOUNTING NEW YORK<CR><LF>
20 RESEARCH DALLAS<CR><LF>
30 SALES CHICAGO<CR><LF>
40 OPERATIONS BOSTON<CR><LF>

However, you want to generate a spool file like this:

10 ACCOUNTING NEW YORK<LF>
20 RESEARCH DALLAS<LF>
30 SALES CHICAGO<LF>
40 OPERATIONS BOSTON<LF>

How to Remove the Carriage Return (CR) characters from SQL*Plus Spooled Output on windows?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.