On Wed, Oct 20, 2010 at 1:04 PM, Mark Kimpel <mwkim...@gmail.com> 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.
>
> Anybody know what character or ASCII code to use for this?
>
You don't need to do anything special provided you enclose the
multi-line fields in double quotes. For example, this works for me
using Excel 2007:
cat('HdgA,HdgB\n"A\nB",C\n', file = "my-excel-test.csv")
shell("my-excel-test.csv")
Note that you may need to stretch the cells in Excel to actually see
the multiple lines in the multi-line cells but they are there in any
case.
--
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com
______________________________________________
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.
