Actually 0&". Seems to convert number strings containing commas OK.
0 ". > '123,555';'253,562.26' 123555 253562 On Fri, 19 Feb 2021, 02:27 Ric Sherlock, <[email protected]> wrote: > My initial reaction is that the tables/csv add on should read those OK, > the issue will be converting the number strings in the cells to numbers. > If there are no meaningful commas other than the field delimiters, > couldn't > you use -.&','each after readcsv to remove them? > Alternatively: > TAB fixdsv -.&',' TAB makedsv readcsv 'file.csv' > > > > > On Thu, 18 Feb 2021, 23:55 R.E. Boss, <[email protected]> wrote: > >> Actually, my question is: I have a comma separated file which contains >> numbers with a comma as thousands separator, enclosed between double quotes >> ("). >> How can I read these, without doing a lot of tailor made pre-processing? >> >> >> R.E. Boss >> >> >> -----Original Message----- >> From: Programming <[email protected]> On Behalf >> Of bill lam >> Sent: donderdag 18 februari 2021 11:31 >> To: Programming forum <[email protected]> >> Subject: Re: [Jprogramming] csvedit >> >> I think this addon depends on another grid addon which had been >> decommited many years ago. >> >> On Thu, Feb 18, 2021, 6:22 PM R.E. Boss <[email protected]> wrote: >> >> > >> > Where has https://code.jsoftware.com/wiki/Addons/tables/csvedit gone? >> > I could only find it in \j64-602\addons\tables\csvedit >> > >> > >> > R.E. Boss >> > ---------------------------------------------------------------------- >> > 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
