removing first blank line in csv file

Expand Post »

Hi,
I have written a sql script which takes the rows from a table and writes it to
a .csv file.

The script is as follows:-

Oracle Syntax (Toggle Plain Text)
 SET feedback off;
 spool output.csv;
 SET heading off;
 SELECT username||','||profession FROM users;
 spool off;
 set feedback off;
 spool output.csv;
 set heading off;
 SELECT username||','||profession from users;
 spool off;

This works fine but output.csv contains a blank line at the top.
How can I get rid of that blank line?

Thanks in advance

Similar Threads

How to read csv file contents in VB.Net in VB.NET
Delete Blank line(s) from a textbox? in VB.NET
please help:write to a text file but got a blank first line. in C++
Parsing a CSV File and inserting into a dictionary in Python
read second line or record of csv file in PHP

axeeffect2002

Reputation Points: 35

Solved Threads: 4

Light Poster

Offline

33 posts
since Jul 2009

Permalink

Sep 23rd, 2009

Re: removing first blank line in csv file

You have to add command SET PAGESIZE 0 at the top script

Oracle Syntax (Toggle Plain Text)
SET PAGESIZE 0       -- <-- add this line
 
SET FEEDBACK OFF
SET HEADING OFF
 
SPOOL OUTPUT.TXT;
SELECT username||','||profession FROM users;
SPOOL OFF;
SET PAGESIZE 0       -- <-- add this line

SET FEEDBACK OFF
SET HEADING OFF

SPOOL OUTPUT.TXT;
SELECT username||','||profession FROM users;
SPOOL OFF;

babyDBA

Reputation Points: 10

Solved Threads: 4

Newbie Poster

Offline

8 posts
since Sep 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Oracle Forum Timeline: Multiple row insertion

Next Thread in Oracle Forum Timeline: Sql query to get max 5 values

DaniWeb Message

Cancel Changes

User Name
Password