agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Rob Sargent <robjsargent@gmail.com>
To: Scott@BITSnBYTES.io, Steve Midgley <science@misuse.org>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Subject: Re: ERROR: extra data after last expected column
Date: Mon, 7 Mar 2022 19:40:08 -0700
Message-ID: <1101975f-ef74-3634-14c4-b7ee624139ea@gmail.com> (raw)
In-Reply-To: <354e10f466876aad50a77fa6fcb49206c29e678f.camel@gmail.com>
References: <775429fc5428ca2640f72f1d29f6e8ec90955e6c.camel@gmail.com>
<CAKyoTgZ6gc-5_SocE55vbD50Mmhd4iP-A3j0mu-RHq+aTu94Lg@mail.gmail.com>
<a9c205a0-501c-ac7b-2b5c-7c25742ecef6@gmail.com>
<CACCHZrSQ_RvChnzR1nSzGBNpoPevhZvWiZg9bv0JdGHBEamP+A@mail.gmail.com>
<CAJexoS+0u7beHrgHHyYMXJczQt68XyevKOYijyH0Cg8h8iubxQ@mail.gmail.com>
<CAJexoSJy4SK9QkVLLsnxAzchmxprYYf_-E6+QVuoFfJRgP4S+A@mail.gmail.com>
<354e10f466876aad50a77fa6fcb49206c29e678f.camel@gmail.com>
On 3/7/22 18:51, Scott Macri wrote:
> It looks like it might have something to do with the line length. All
> the output from the AWK command are a continuation of the line above
> it. There is no line break, however. I'm investigating now.
>
>
> So I guess when I ran:
> awk -F "|" '{if (NF != 25) print}'
> the first time it was against the wrong file. I just tried again and
> it produced a bunch of output. So this is telling me there are extra
> '|' in those lines?
>
> -- Hacktorious
Can't tell for sure but could be mac/dos/unix EOLN mixup. Some tools are
better than others in dealing with a mixture of those.
view thread (12+ messages) latest in thread
Message-ID: <1101975f-ef74-3634-14c4-b7ee624139ea@gmail.com>
Permalink: ../1101975f-ef74-3634-14c4-b7ee624139ea@gmail.com/
Also on: postgresql.org/message-id/1101975f-ef74-3634-14c4-b7ee624139ea@gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: robjsargent@gmail.com, science@misuse.org, pgsql-sql@lists.postgresql.org
Subject: Re: ERROR: extra data after last expected column
In-Reply-To: <1101975f-ef74-3634-14c4-b7ee624139ea@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox