I get this: load 'pacman' 'search' jpkg 'csv' +----------+-----+-----+------------------------------------+ |tables/csv|1.0.7|1.0.7|Read and write CSV files and strings| +----------+-----+-----+------------------------------------+
9!:14 '' NB. version j701/2011-02-23/15:25 I don't know enough about the differences between J6 and J7 to comment on your results. On Sun, Jan 8, 2012 at 9:16 PM, Devon McCormick <devon...@gmail.com> wrote: > In J6, I get this: > > 'search' jpkg 'csv' > +--------------+-----+-----+------------------------------------+ > |tables/csv |1.0.7|1.0.7|Read and write CSV files and strings| > +--------------+-----+-----+------------------------------------+ > |tables/csvedit|0.0.6|0.0.6|Grid based editor for CSV files | > +--------------+-----+-----+------------------------------------+ > whereDefined 'writecsv' > C:\Program Files\j602\system\packages\files\csv.ijs > > > On Tue, Jan 3, 2012 at 7:56 PM, Ric Sherlock <tikk...@gmail.com> wrote: > > > Interesting. You get different results to me. Are you using the > > tables/csv addon and if so which version? > > > > load 'pacman' > > 'search' jpkgv 'csv' > > ┌──────────┬─────┬─────┬────────────────────────────────────┐ > > │tables/csv│1.0.7│1.0.7│Read and write CSV files and strings│ > > └──────────┴─────┴─────┴────────────────────────────────────┘ > > load 'tables/csv' > > (i. 5 5) writecsv '~temp/foo.csv' > > 70 > > fread '~temp/foo.csv' > > 0,1,2,3,4 > > 5,6,7,8,9 > > 10,11,12,13,14 > > 15,16,17,18,19 > > 20,21,22,23,24 > > > > > > On Wed, Jan 4, 2012 at 1:43 PM, Devon McCormick <devon...@gmail.com> > > wrote: > > > (i. 5 5) writecsv 'foo.csv' > > > 120 > > > fread 'foo.csv' > > > "0","1","2","3","4" > > > "5","6","7","8","9" > > > "10","11","12","13","14" > > > "15","16","17","18","19" > > > "20","21","22","23","24" > > > > > > Also, I was long under the impression that literal data in a csv file > > > should be quoted but apparently this is not the case. It's hard to say > > for > > > sure as there is no real spec for this format, and I don't remember > what > > > disabused me of this notion (perhaps taking the behavior of Excel as > the > > > paradigm?) > > > > > > On Tue, Jan 3, 2012 at 6:35 PM, Ric Sherlock <tikk...@gmail.com> > wrote: > > > > > >> Note that the tables/csv addon is just a special case of the > > >> tables/dsv addon that sets the delimiters. From memory the tables/csv > > >> addon will quote literal data but not numeric data. Of course that > > >> means that numbers in literal form will end up being quoted. > > >> > > >> When you refer to "spurious" double-quotes, are there occasions where > > >> quotes appear that they shouldn't? > > >> > > >> On Wed, Jan 4, 2012 at 9:59 AM, Devon McCormick <devon...@gmail.com> > > >> wrote: > > >> > At some of the recent NYCJUGs, Ken Lettow pointed me to the "dsv" > > >> versions > > >> > of this which are more general ("Delimiter-Separated Values"). I > use > > >> these > > >> > now as I usually prefer tab-delimited files and want to avoid the > > >> spurious > > >> > double-quotes the "csv" modules put around data. See > > >> > > http://www.jsoftware.com/jwiki/Addons/tables/dsv?highlight=%28dsv%29. > > >> > > > >> > On Mon, Jan 2, 2012 at 12:59 PM, Tom Szczesny <tav...@gmail.com> > > wrote: > > >> > > > >> >> When I try require 'csv' I get > > >> >> not found: /home/tom/jgplsrc/j/addons/tables/csv/csv.ijs > > >> >> > > >> >> However, I can get to > > >> >> http://www.jsoftware.com/jwiki/Addons > > >> >> I should be able to get what I need from there. > > >> >> > > >> >> Thanks. > > >> >> > > >> >> > > >> >> On Mon, Jan 2, 2012 at 12:38 PM, Raul Miller < > rauldmil...@gmail.com> > > >> >> wrote: > > >> >> > > >> >> > Try this: > > >> >> > > > >> >> > require 'csv' > > >> >> > > > >> >> > T=: readcsv '/home/tom/t.csv' > > >> >> > > > >> >> > -- > > >> >> > Raul > > >> >> > > > >> >> > On Mon, Jan 2, 2012 at 12:22 PM, Tom Szczesny <tav...@gmail.com> > > >> wrote: > > >> >> > > Some languages, like q, have a built-in command for reading, > > >> parsing, > > >> >> and > > >> >> > > loading data from csv files: > > >> >> > > t: ("SSDIDSSIFFFIS";enlist ",") 0: `:/home/tom/t.csv > > >> >> > > > > >> >> > > Other languages, like a+, do not, and the user needs to write a > > >> >> function > > >> >> > to > > >> >> > > read, parse and load data from csv files. > > >> >> > > > > >> >> > > From a cursory review, it appears that j is in the a+ camp. > > >> >> > > Please confirm that such a facility does not exist in j, > before I > > >> start > > >> >> > > writing my own. > > >> >> > > > > >> ---------------------------------------------------------------------- > > >> >> > > 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 > > >> >> > > >> > > > >> > > > >> > > > >> > -- > > >> > Devon McCormick, CFA > > >> > ^me^ at acm. > > >> > org is my > > >> > preferred e-mail > > >> > > ---------------------------------------------------------------------- > > >> > For information about J forums see > > http://www.jsoftware.com/forums.htm > > >> ---------------------------------------------------------------------- > > >> For information about J forums see > http://www.jsoftware.com/forums.htm > > >> > > > > > > > > > > > > -- > > > Devon McCormick, CFA > > > ^me^ at acm. > > > org is my > > > preferred e-mail > > > ---------------------------------------------------------------------- > > > For information about J forums see http://www.jsoftware.com/forums.htm > > ---------------------------------------------------------------------- > > For information about J forums see http://www.jsoftware.com/forums.htm > > > > > > -- > Devon McCormick, CFA > ^me^ at acm. > org is my > preferred e-mail > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm