[R] ascii or regex code for alt-enter for Excel

[William Dunlap]

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.) 

Bill Dunlap
Spotfire, TIBCO Software
wdunlap tibco.com  

> -----Original Message-----
> From: r-help-bounces at r-project.org 
> [mailto:r-help-bounces at r-project.org] On Behalf Of Duncan Murdoch
> Sent: Wednesday, October 20, 2010 10:29 AM
> To: Mark Kimpel
> Cc: r-help at 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 at 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 at 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.
>