How To Remove The Carriage Return (CR) Characters From SQL*Plus Spooled Output On Windows
(Doc ID 1638278.1)
Last updated on FEBRUARY 16, 2018
Applies to:SQL*Plus - Version 10.2.0.4 and later
Information in this document applies to any platform.
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>.
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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!