Well, both your advices work as predicted.
I did not think readcsv would handle the double quotes in an appropriate way,
but that I didn't try it is worse.
And 0&". is a superb trick, where did you find that?
Thanks.
R.E. Boss
-----Original Message-----
From: Programming <programming-boun...@forums.jsoftware.com> On Behalf Of Ric
Sherlock
Sent: donderdag 18 februari 2021 14:38
To: Programming forum <programm...@jsoftware.com>
Subject: Re: [Jprogramming] csvedit
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, <tikk...@gmail.com> 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, <r.e.b...@outlook.com> 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 <programming-boun...@forums.jsoftware.com> On
>> Behalf Of bill lam
>> Sent: donderdag 18 februari 2021 11:31
>> To: Programming forum <programm...@jsoftware.com>
>> 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 <r.e.b...@outlook.com> 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
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
