Groups | Search | Server Info | Login | Register

Groups > comp.lang.awk > #9828

Re: [gawk] Handling variants of CSV input data formats

Path csiph.com!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From Manuel Collado <mcollado2011@gmail.com>
Newsgroups comp.lang.awk
Subject Re: [gawk] Handling variants of CSV input data formats
Date Mon, 26 Aug 2024 19:01:02 +0200
Organization A noiseless patient Spider
Lines 20
Message-ID <ed42d44f-902e-40c1-956f-a3d5c215682c@gmail.com> (permalink)
References <vaeh9m$1pfge$1@dont-email.me> <vahop1$2eavu$1@dont-email.me> <vahttd$2f666$1@dont-email.me>
MIME-Version 1.0
Content-Type text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding 8bit
Injection-Date Mon, 26 Aug 2024 19:01:02 +0200 (CEST)
Injection-Info dont-email.me; posting-host="e61734a7efa521175c32eae97b54fa08"; logging-data="2676944"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+wNSsD/v8Alhsc0eHfIfpwAnJOeVfSJTk="
User-Agent Mozilla Thunderbird
Cancel-Lock sha1:msScuC+0w8ReIrVJAo3YSXCavjs=
In-Reply-To <vahttd$2f666$1@dont-email.me>
Content-Language en-US, es-ES
Xref csiph.com comp.lang.awk:9828

Show key headers only | View raw

El 26/8/24 a las 14:54, Janis Papanagnou escribió:
> 
> My opinion on this is that I wouldn't expect GNU Awk to become a (yet
> another) CSV-processor. It's very convenient to have an easy input of
> CSV data to be processed like other tabular data with Awk. So removal
> of the (outer) quotes, transforming "inner" quotes of fields according
> to the CSV-standard(s), and handling the escape symbol, would serve my
> expectations. (I don't need CSV-output formatting, but I understand if
> there is such a demand.)

Perhaps you could try my gawk-csvio pure gawk library. Just include a 
first unconditional rule calling csvimport(...) and the CSV input data 
will be automatically converted to a regular OFS-delimited record ready 
to be processed.

Please find the library at http://mcollado.z15.es/gawk-extras/. The 
documentation is available also to be read before downloading.

HTH

Back to comp.lang.awk | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

[gawk] Handling variants of CSV input data formats Janis Papanagnou <janis_papanagnou+ng@hotmail.com> - 2024-08-25 08:00 +0200
  Re: [gawk] Handling variants of CSV input data formats Ed Morton <mortonspam@gmail.com> - 2024-08-26 06:26 -0500
    Re: [gawk] Handling variants of CSV input data formats Janis Papanagnou <janis_papanagnou+ng@hotmail.com> - 2024-08-26 14:54 +0200
      Re: [gawk] Handling variants of CSV input data formats Manuel Collado <mcollado2011@gmail.com> - 2024-08-26 19:01 +0200
        Re: [gawk] Handling variants of CSV input data formats Janis Papanagnou <janis_papanagnou+ng@hotmail.com> - 2024-08-27 02:31 +0200
          Re: [gawk] Handling variants of CSV input data formats Manuel Collado <mcollado2011@gmail.com> - 2024-08-27 12:20 +0200
            Re: [gawk] Handling variants of CSV input data formats Janis Papanagnou <janis_papanagnou+ng@hotmail.com> - 2024-08-27 18:19 +0200
      Re: [gawk] Handling variants of CSV input data formats Ed Morton <mortonspam@gmail.com> - 2024-08-26 19:49 -0500
        Re: [gawk] Handling variants of CSV input data formats Janis Papanagnou <janis_papanagnou+ng@hotmail.com> - 2024-08-27 03:39 +0200
          Re: [gawk] Handling variants of CSV input data formats Ed Morton <mortonspam@gmail.com> - 2024-08-27 06:45 -0500
            Re: [gawk] Handling variants of CSV input data formats Janis Papanagnou <janis_papanagnou+ng@hotmail.com> - 2024-08-27 18:23 +0200

csiph-web