Okay, given it’s that easy, don’t do preprocessing
if you have homogeneous files from this one source only.
IIUC, it should now suffice to
, _2 {.\ 0&".;._1 LINE
(if you won’t ever have 0s, you can simplify)
Am 18.02.21 um 14:37 schrieb Ric Sherlock:
> 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
>
--
----------------------
mail written using NEO
neo-layout.org
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
