How did you open the file? e.g. Do you know the exact encoding of the data, as you should then use that knowledge to open the file

my $csv = Text::CSV_XS->new ({ binary => 1, auto_diag => 1 });
open my $fh, "<:encoding(utf-8)", $filename or die "...";
while (my $row = $csv->getline ($fh)) {
    ...
[download]

Is the data "private" or can I get a copy of the file?

Not knowing the Text::CSV module at all, I read the error message like this:

"There is a CR - carriage return inside of your CSV data, but it is not at the end-of-line."

I understand: the operating system where you are getting this message is not using carriage return+line feed as the end-of-line marker, but maybe just the line feed.

This may seem strange, but maybe it is all there is to it.

Have you tried dos2unix or something similar on your data or would that break it?

If it doesn't succeed, the CR might be somewhere inside the data, not anywhere close to the end-of-line."

Cheers, Sören

Completely wrong. All of it. Text::CSV_XS automatically deals with CR and/or NL in CSV streams/files.

When in doubt, read the manpage:

2023 "EIQ - QUO character not allowed" 

Sequences like "foo "bar" baz",quux and 2023,",2008-04-05,"Foo, Bar",\
+n will cause this error.
[download]

update: Sorry for that tone. I got sidetracked by the wrong paste in the OT. He used a message-code mismatch. I look at codes

2032 "EIF - CR char inside unquoted, not part of EOL"
[download]

2032 != 2023. Most of the time, NOT passing eol to the constructor is likely to solve the issue


Enjoy, Have FUN! H.Merijn

Text::CSV_XS automatically deals with CR and/or NL in CSV streams/files.

Well the documentation (that I claim not to know :-P) says otherwise:

This means that fields can not contain newlines. If your data contains newlines embedded in fields, or characters above 0x7e (tilde), or binary data, you *must* set binary => 1 in the call to new (). To cover the widest range of parsing options, you will always want to set binary.

Still I haven't been able to reproduce the OP's error yet.

Cheers, Sören