Post reply

Exporting to CSV with (") as text delimiter

  • February 2, 2005 at 2:31 am

    #540103

    I bet you are not making this mistake, but I once did, so just in case....

    I wrote an export to csv (not from SQL Server), expecting " around the text fields. I then wanted to check the output, and without even thinking about it, chose Excel. That was a smart move. It was a while ago, when Notepad had its 64k restriction, and the file was big. But when I opened it, there was no " anywhere.

    It's amazing how long I can go (and how much code I can stare at, wondering where the error is) before seeing the obvious. Excel doesn't show the " on an automatically imported csv.... big DOH! moment.

    Bill.

  • February 2, 2005 at 7:35 am

    #540158

    Bill,

     

    Thanks for the reply.  I am using just a few rows to test the export and opening it in Notepad.  Again, no quotes around text fields.  Very frustrating!

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply