Re: ERROR: extra data after last expected column

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.
>
>