From: | scott macri <hacktorious(at)gmail(dot)com> |
---|---|
To: | Rob Sargent <robjsargent(at)gmail(dot)com> |
Cc: | Steve Midgley <science(at)misuse(dot)org>, pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
Subject: | Re: ERROR: extra data after last expected column |
Date: | 2022-03-08 03:47:23 |
Message-ID: | CACCHZrQ-CH-d8WRCWN1b=iLCqrauNRm5QPGZyN8Fz9O1D+Oh5Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
On Mon, Mar 7, 2022, 9:40 PM Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
> 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.
>
> I found an extra pipe character at the end of each line. It seems like
> the data coming from the sender is messed up. Gotta take a closer look
> tomorrow and determine the best plan of action.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | BeginnerC | 2022-03-08 09:44:30 | A simple question: Why 'pg_ctl: command not found...' ? |
Previous Message | Rob Sargent | 2022-03-08 02:40:08 | Re: ERROR: extra data after last expected column |
From | Date | Subject | |
---|---|---|---|
Next Message | Sebastien Flaesch | 2022-03-08 15:38:24 | Re: Best practice for naming temp table trigger functions |
Previous Message | Rob Sargent | 2022-03-08 02:40:08 | Re: ERROR: extra data after last expected column |