Horton

Re: ERROR: extra data after last expected column

Rob Sargent <robjsargent@gmail.com>

View thread View on postgr.es
From: Rob Sargent <robjsargent@gmail.com>
To: Scott@BITSnBYTES.io, Steve Midgley <science@misuse.org>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Date: 2022-03-08T02:40:08Z
Lists: pgsql-general, pgsql-sql 
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.