# Exporting to delimited text without headers leaves an empty line at the beginning of the file

**URL:** <https://forums.toadworld.com/t/exporting-to-delimited-text-without-headers-leaves-an-empty-line-at-the-beginning-of-the-file/18384>\
**Category:** Toad for SQL Server\
**Created:** [June 9, 2013, 7:30am UTC](https://forums.toadworld.com/t/exporting-to-delimited-text-without-headers-leaves-an-empty-line-at-the-beginning-of-the-file/18384 "2013-06-09T07:30:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![asant](https://avatars.discourse-cdn.com/v4/letter/a/dc4da7/32.png) [@asant](https://forums.toadworld.com/u/asant)\
**Post date:** [June 9, 2013, 7:30am UTC](https://forums.toadworld.com/t/exporting-to-delimited-text-without-headers-leaves-an-empty-line-at-the-beginning-of-the-file/18384/1 "2013-06-09T07:30:43Z")

</div>

Hello all,

I have a custom data importer for a data warehouse that accepts text files whose lines are formatted as lists (just like those in csv’s, but with a different separator). The importer accepts such files only when there are no blank lines.

Now I’m having a problem with the export wizard: whenever I export some query results to delimited text and I choose not to include the column headers, I always find out that the resulting file has an empty line at the beginning.

Since opening the file with a text editor just to delete the first line isn’t always possible because of the file size, I wanted to ask you whether there’s any way to workaround this problem.

Please note: the version of Toad for SQL Server I’m using is 6.0.0.323, but I remember that version 5.6 didn’t use to cause this issue.

Thank you very much in advance.

---

<div class="post-metadata">

**Author:** ![Julia.A.Trevgoda2013](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/julia.a.trevgoda2013/32/187_2.png) [@Julia.A.Trevgoda2013](https://forums.toadworld.com/u/Julia.A.Trevgoda2013)\
**Post date:** [June 11, 2013, 3:40am UTC](https://forums.toadworld.com/t/exporting-to-delimited-text-without-headers-leaves-an-empty-line-at-the-beginning-of-the-file/18384/2 "2013-06-11T03:40:27Z")

</div>

Hello,

Sorry for the inconvenience.

Actually this is a bug and no workaround available for this issue. We’ve created CR#110087 already to correct it.

regards, Julia

---

<div class="post-metadata">

**Author:** ![asant](https://avatars.discourse-cdn.com/v4/letter/a/dc4da7/32.png) [@asant](https://forums.toadworld.com/u/asant)\
**Post date:** [June 11, 2013, 9:14am UTC](https://forums.toadworld.com/t/exporting-to-delimited-text-without-headers-leaves-an-empty-line-at-the-beginning-of-the-file/18384/3 "2013-06-11T09:14:04Z")

</div>

Thank you very much for your quick answer and help, Julia.

Regards.