The tables/csv addon will handle this:
load 'tables/csv'
('a';('b',LF,'c',LF,'d');'e'),:'a';'a';'a'
+-+-----+-+
|a|b c d|e|
+-+-----+-+
|a|a |a|
+-+-----+-+
makecsv ('a';('b',LF,'c',LF,'d');'e'),:'a';'a';'a'
"a","b
c
d","e"
"a","a","a"
fixcsv makecsv ('a';('b',LF,'c',LF,'d');'e'),:'a';'a';'a'
+-+-----+-+
|a|b c d|e|
+-+-----+-+
|a|a |a|
+-+-----+-+
> From: bill lam
>
> 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
