Re: ERROR: extra data after last expected column
От | scott macri |
---|---|
Тема | Re: ERROR: extra data after last expected column |
Дата | |
Msg-id | CACCHZrQ-CH-d8WRCWN1b=iLCqrauNRm5QPGZyN8Fz9O1D+Oh5Q@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: ERROR: extra data after last expected column (Rob Sargent <robjsargent@gmail.com>) |
Список | pgsql-sql |
On Mon, Mar 7, 2022, 9:40 PM Rob Sargent <robjsargent@gmail.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.
В списке pgsql-sql по дате отправления: