Community discussion forum

save .csv with newline character

• • Reply

  1 year ago

  by bahamas_again

  bahamas_again

  , United States

  Joined 4 years ago
  i'm creating a .csv file on the fly, thus am enclosing all the data within double quotes. how to put in a newline character is the problem. for eg:- i tried the following - "header1","header2","header3"\n"data1","data2","data3"\n"data11","data22","data33" and "header1","header2","header3 \n"\r\n "data1","data2","data3 \n"\r\n "data11","data22","data33" so that the output looks like header1 header2 header3 data1 data2 data3 data11 data22 data33 thanks a lot for your help
  Post was edited on 19/11/2008 10:58:59 Report abuse
• • Reply

  1 year ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 8 years ago
  Which bit of your data needs to actually contain the newline? According to this post: [http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm#EmbedBRs](http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm#EmbedBRs) you can actually leave the new lines inline, so something like this, is valid: Conference room 1, "John, Please bring the M. Mathers file for review -J.L. ",10/18/2002,... as the line breaks are within the double quotes. Hope that helps!
  Report abuse