Note also: assign2hdr readcsv 'c:\tst1.csv'
col1 +---+---+----+ |abc|def|ghij| +---+---+----+ col2 +----+----+----+ |c101|c102|c201| +----+----+----+ col3 1 1 2 On Fri, Mar 4, 2016 at 1:04 PM, Ric Sherlock <[email protected]> wrote: > Many of the addons have documentation on the wiki: > Note that the 'tables/csv' addon > http://code.jsoftware.com/wiki/Addons/tables/csv > > is a special case of the 'tables/dsv' addon which lets you specify custom > delimiters. > http://code.jsoftware.com/wiki/Addons/tables/dsv > > On Fri, Mar 4, 2016 at 12:16 PM, Raul Miller <[email protected]> > wrote: > >> It could probably use better documentation. >> >> For now... there's a brief reference left over from j602: >> http://www.jsoftware.com/docs/help602/user/script_csv.htm >> >> Also, there's the NB. comments that you can read if you run: >> open 'csv' >> >> Note also that this probably requires that you have installed the >> tables/csv addon. (Though, personally, I always just do (install'all') >> in jconsole in any fresh J installation.) >> >> Thanks, >> >> -- >> Raul >> >> >> On Thu, Mar 3, 2016 at 6:06 PM, Skip Cave <[email protected]> >> wrote: >> > Thanks Raul, that worked perfectly! >> > Where is that command documented? I looked for awhile, but couldn't find >> > any clear docs. >> > >> > >> > On Thu, Mar 3, 2016 at 4:25 PM, Raul Miller <[email protected]> >> wrote: >> > >> >> Unless it's huge, I think I'd go: >> >> >> >> require'csv' >> >> list=: readcsv 'c:\tst1.csv' >> >> >> >> Thanks, >> >> >> >> -- >> >> Raul >> >> >> >> >> >> On Thu, Mar 3, 2016 at 5:20 PM, Skip Cave <[email protected]> >> wrote: >> >> > I have a text file that looks like this: >> >> > >> >> > col1,col2,col3 >> >> > abc,c101,1 >> >> > def,c102,1 >> >> > ghij,c201,2 >> >> > >> >> > the file name is "tst1.csv" >> >> > >> >> > The location of the file is C:\tst1.csv >> >> > >> >> > i want to read the file into a boxed J array >> >> > called "list" >> >> > >> >> > list >> >> > >> >> > ┌────┬────┬────┐ >> >> > │col1│col2│col3│ >> >> > ├────┼────┼────┤ >> >> > │abc │c101│ >> >> > >> >> > 1 >> >> > >> >> > │ >> >> > ├────┼────┼──── >> >> > >> >> > ┤ >> >> > │def │c102│ >> >> > >> >> > 1 >> >> > >> >> > │ >> >> > ├────┼────┼────┤ >> >> > │ghij│c201│ >> >> > >> >> > 2 >> >> > >> >> > │ >> >> > └────┴────┴────┘ >> >> > >> >> > What utilities have >> >> > t >> >> > o be loaded >> >> > to do this? >> >> > What are the load commands? >> >> > What is the file-read, path, and assignment command(s) required to do >> >> this? >> >> > >> >> > Skip >> >> > >> >> > Skip Cave >> >> > Cave Consulting LLC >> >> > >> ---------------------------------------------------------------------- >> >> > For information about J forums see >> http://www.jsoftware.com/forums.htm >> >> ---------------------------------------------------------------------- >> >> For information about J forums see http://www.jsoftware.com/forums.htm >> > ---------------------------------------------------------------------- >> > For information about J forums see http://www.jsoftware.com/forums.htm >> ---------------------------------------------------------------------- >> For information about J forums see http://www.jsoftware.com/forums.htm >> > > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
