> From: Sherlock, Ric
>
> > From: bill lam
> >
> > eg, for cells
> > -+-+-+
> > |a|b|e|
> > | |c| |
> > | |d| |
> > +-+-+-+
> > |a|a|a|
> > +-+-+-+
> >
> > clipboard of csv as reported by wd'clippaste' will be
> > 97 9 98 10 99 10 100 9 101 10 97 9 97 9 97{a.
>
> Interestingly when I create the described spreadsheet structure in
> Excel 2007, copy it to the clipboard and look at it using wd'clippaste'
> I get the following:
>
> a. i. wd 'clippaste'
> 97 9 34 98 10 99 10 100 34 9 101 13 10 97 9 97 9 97 13 10
>
Using OpenOffice 3.0 on Ubuntu I get the same result as Bill. i.e.
a. i. wd 'clippaste'
97 9 98 10 99 10 100 9 101 10 97 9 97 9 97 10
As I said before - I'm not sure you can expect any routine to parse this
correctly because there is nothing differentiating an embedded-line-break from
an end-of-record.
Note also that the clipboard is TAB-separated not comma-separated so pure csv
routines won't work anyway. The tables/dsv addon will work, but only if the
fields containing embedded line breaks are enclosed with a string delimiter.
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
