TEXT FILE DATA - WRAPPING HELP

[kilabru]

Exporting:
USING: .bat & .ctl to .txt
Exporting is all good and grand.
However, my data keeps wrapping in the .txt file.
End result, my data will not load into tables due to the wrap. All my data needs to stay on one line record.

I have turned wrapping off, but it always wrap. One interesting fact is that each time I open a text document it opens it as minimized, thus causing the wrap. If it is maximized I can bring the data back to one line per record and delete the blank rows and all works well.

Can anyone help?

 

[rcurva]

How did you extract your text file for loading? Is it by using the sqlplus spooling to a file? If this is the case, and your linse are wrapping per record, you may need to SET LINESIZE to a higher value to accomodate your entire record.

But based on your posting, it looks like the text editor that you are using is the one that is wrapping your exported data. You may be opening your text file in this editor (with wrapping on) and saving it, resulting to a damaged file.

Of course, I may be wrong. Please give more details.
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[kilabru]

I believe it is the editor that is doing the wrapping.
Should I try another editor, I have tried the wrapping setting with no solution.

 

[kilabru]

I got it!!
I left out set linesize in the script..
I have had this problem in that past and it slipped my mind.

Thanks,

John