Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

removing first blank line in csv file

 
nandini lagunia
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:-


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
 
Christophe Verré
Sheriff
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You could use SET NEWPAGE NONE;
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic