[Jprogramming] Reading text .csv files into a J array

[Ric Sherlock]

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 <tikkanz at gmail.com> 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 <rauldmiller at gmail.com>
> 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 <skip at caveconsulting.com>
>> 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 <rauldmiller at gmail.com>
>> 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 <skip at caveconsulting.com>
>> 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
>>
>
>