sqlplus spaces buffer

[von2]

I am running a query that spools to a txt file in this manner.

 100 320050406 20050325 119090 1 0 
       345
101 320057806 20050326 112020 1 0 
       440

whereas it should actually display like

100 320050406 20050325 119090 1 0 345
101 320057806 20050326 112020 1 0 440

I have hard time removing the spaces after 0 since the file is big. See, there are spaces before second line that are impossible to remove using wordpad.
The last ine breaks into a second line. I even tried to substring some of the columns in order to reduce extra spaces. Toad displays the output normally. But sqlplus is breaking it with extra spaces.
Can someone help?

 

[dbtoo2001]

set linesize 130
set trimspool on

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch13.htm#1013358

 

[BJCooperIT]

Have you set your LINESIZE? Could you give us a peek at your code?

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
Author and Sole Proprietor of: Emu Products Plus

 

[von2]

Hi,

I set the linesize to 130, 200 and 500 and trimspool on ... They all gave the same messy output. Any other ideas

 

[SantaMufasa]

Von, Please post your SQL code and a "describe <tablename>" of the table(s) involved. Then we can better help you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[sem]

1. That field in table may contain carriage return symbol
2. That column in sql*plus may be defined with that format.

Regards, Dima

http://seminihin.narod.ru