> From: r-help-boun...@r-project.org
> [mailto:r-help-boun...@r-project.org] On Behalf Of William Dunlap
> Sent: Wednesday, October 20, 2010 10:47 AM
> To: Duncan Murdoch; Mark Kimpel
> Cc: r-help@r-project.org
> Subject: Re: [R] ascii or regex code for alt-enter for Excel
>
> I think Excel wants a "\n" for newlines
> in a text cell entry but "\r\n" to separate
> rows of a csv file. You may have to open
> the file in binary mode and put in the \r\n
> at line ends by hand to achieve this from R,
> as it tranlates all "\n"s to "\r\n"s when
> writing them to a file.
>
> ("\n" is not the same as "/n" in R.)
I omitted an example:
d <- data.frame(nLines=c(3,2,1),
entry=c("three\nline\nentry",
"two line\nentry",
"one line entry"))
theFile <- file("c:/temp/d.csv", open="wb") # write in binary mode
write.csv(d, theFile, eol="\r\n")
close(theFile)
Now c:/temp/d.csv in Excel and you should see the
multiline text entries. (Expand the cells and/or
formula entry area to see all the lines in an entry.)
> Bill Dunlap
> Spotfire, TIBCO Software
> wdunlap tibco.com
>
> > -----Original Message-----
> > From: r-help-boun...@r-project.org
> > [mailto:r-help-boun...@r-project.org] On Behalf Of Duncan Murdoch
> > Sent: Wednesday, October 20, 2010 10:29 AM
> > To: Mark Kimpel
> > Cc: r-help@r-project.org
> > Subject: Re: [R] ascii or regex code for alt-enter for Excel
> >
> > On 20/10/2010 1:04 PM, Mark Kimpel wrote:
> > > I need to write a table that can be opened in Excel or
> > OpenOffice such that
> > > there are newlines embedded within cells.
> > >
> > > After much Googling and futzing, I can't figure out how to
> > do this. The way
> > > to do this within Excel is alt-Enter and I've tried '/n',
> > '/n/r', '/r/n' per
> > > some web suggestions without luck.
> >
> > You may need to ask an Excel expert or MS tech support. What
> > character
> > is Excel looking for?
> >
> > (Or it is possible that you have what you need, but used
> > forward slashes
> > when you should have used backslashes. The newline character
> > is \n, not
> > /n, in R.)
> >
> > Duncan Murdoch
> >
> > > Anybody know what character or ASCII code to use for this?
> > >
> > > Thanks,
> > >
> > > Mark
> > >
> > > Mark W. Kimpel MD ** Neuroinformatics ** Dept. of Psychiatry
> > > Indiana University School of Medicine
> > >
> > > 15032 Hunter Court, Westfield, IN 46074
> > >
> > > (317) 490-5129 Work,& Mobile& VoiceMail
> > > (317) 399-1219 Skype No Voicemail please
> > >
> > > [[alternative HTML version deleted]]
> > >
> > > ______________________________________________
> > > R-help@r-project.org mailing list
> > > https://stat.ethz.ch/mailman/listinfo/r-help
> > > PLEASE do read the posting guide
> > http://www.R-project.org/posting-guide.html
> > > and provide commented, minimal, self-contained, reproducible code.
> >
> > ______________________________________________
> > R-help@r-project.org mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide
> > http://www.R-project.org/posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
> >
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
