Print to CSV problem

[jaypotter]

I am using the code below to send data to a csv file. When it displays in the file, then last column puts am " at the end of the column. I have tried to different variations of "\"\n" and I can't get it right. I have attached a screen shot of the csv file.  Any help is greatly appreciated.

 

    header("Content-type:text/octect-stream");

    header("Content-Disposition:attachment;filename=data.csv");

 

print 'Vendor,Name' . "\"\n";

print 'Vendor2,Name2' . "\"\n";

 

 

 

 

[attachment deleted by admin]

[Buddski]

Have you tried

    header("Content-type:text/octect-stream");
    header("Content-Disposition:attachment;filename=data.csv");

   print 'Vendor,Name' . "\n";
   print 'Vendor2,Name2' . "\n";

[JAY6390]

print '"Vendor","Name"' . "\n";
print '"Vendor2,Name2"' . "\n";

Not sure which of the above you were after to be honest, but hopefully it was one of them

[jaypotter]

This worked! I thought I had tried that earlier, but I guess I didn't. Thanks

 

  header("Content-type:text/octect-stream");

    header("Content-Disposition:attachment;filename=data.csv");

 

  print 'Vendor,Name' . "\n";

  print 'Vendor2,Name2' . "\n";