If you are into Excel you might want to look at Tara and of course it could be interesting for you to take a look at grid in J there are some utils that work with CSV and Grid
2007/10/2, David Porter <[EMAIL PROTECTED]>: > > I have read a CSV file and crunched it appropriately. I am now trying > to write the crunched file with normal negative signs. I remember > reading about an elegant way to replace the negative signs and saying to > myself at the time: "That's a good thing to remember." However, I > cannot find the reference that I think I saw and am now starting to > question whether I did see it. > > I am using J 5.04. I have a two-dimensional array of numbers that gets > a text header attached to it, both as boxed arrays. This gets fed to > the writecsv verb from the csv script that came with J 5.04. I can > change data to character data and the negative signs to hyphens by > working on the data as a vector, but cannot get it boxed correctly to > attach the header. > > I looked in the OLE stuff to export data to Excel, but couldn't find > anything there, though I may have missed it. > > Thinking out of the box, could I just swap the characters in a. while I > write the file or is a. read-only? (Doesn't seem to work.) > > Seems like it should be easy...doh! > > Thanks in advance > Dave Porter > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > -- Björn Helgason, Verkfræðingur Fugl&Fiskur ehf, Þerneyjarsund 23, Box 127 801 Grímsnes ,t-póst: [EMAIL PROTECTED] Skype: gosiminn, gsm: +3546985532 Landslags og skrúðgarðagerð, gröfuþjónusta http://groups.google.com/group/J-Programming Tæknikunnátta höndlar hið flókna, sköpunargáfa er meistari einfaldleikans góður kennari getur stigið á tær án þess að glansinn fari af skónum /|_ .-----------------------------------. ,' .\ / | Með léttri lund verður | ,--' _,' | Dagurinn í dag | / / | Enn betri en gærdagurinn | ( -. | `-----------------------------------' | ) | (\_ _/) (`-. '--.) (='.'=) `. )----' (")_(")
---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
