Not confirmed:
[dat=.a. i. wd'clippaste'
97 9 34 98 10 99 10 100 34 9 101 13 10
fixcsv dat{a.
+------------+
|a "b c d" e |
+------------+
R.E. Boss
> -----Oorspronkelijk bericht-----
> Van: [email protected] [mailto:programming-
> [email protected]] Namens bill lam
> Verzonden: dinsdag 27 oktober 2009 15:53
> Aan: JProgramming
> Onderwerp: [Jprogramming] force line breaks in csv
>
> text inside a spreadsheet cell can be multiline by forcing line break
> using alt-enter in window and linux. I found that block of cells
> containing line break can be copy-and-paste within spreadsheet. But
> csv verbs inside J base library seemed cannot handle that.
>
> 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.
>
> but
> load 'csv'
> fixcsv dat=. 97 9 98 10 99 10 100 9 101 10 97 9 97 9 97{a.
> +---+
> |a b|
> +---+
> |c |
> +---+
> |d e|
> +---+
>
> which is not the 2x3 block.
>
> --
> regards,
> ====================================================
> GPG key 1024D/4434BAB3 2008-08-24
> gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3
> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
