Object reference error when using a CSV file with Mac line endings about csvhelper

[JoshClose]

Do you have a file that reproduces the issue?

[ksouthworth]

Yes, how do i upload it?

[ksouthworth]

Also, I have a workaround that appears to work. I'm reading the input into a string, normalizing the line endings to Windows format CRLF and then converting that back into a stream before passing it in to the CsvReader.

Code snippet i'm using:

            string inputString = reader.ReadToEnd();
            string normalizedLineEndings = Regex.Replace(inputString, @"\r\n|\n|\r", "\r\n");

[JoshClose]

Can you email me the file?

I have a feeling that using a Regex will slow down performance quite a bit.

[JoshClose]

If you change the check in the parser for '\n' to a '\r', your file works correctly. I can add an option for settings the line terminator with a default of '\n', and you could set it to '\r' if the file needs that.

Let me know if that solves the issue for you.

I will look into having it automatically figure it out also, but I haven't given any thought to if that's a good idea yet.

[JoshClose]

I put a new version up that allows you to choose what the line ending is. I tested with your file, and it should work fine if you just change the line ending to \r instead of the default \n.

[ksouthworth]

Haven't tested yet, but my problem is that I don't know ahead of time which line ending the files will have (the file is uploaded by the user). So I can't hard-code the line terminator...

[JoshClose]

Ok, I will have to give that some thought. I think I should be able to do it fairly easily if I only worry about \r and \n line terminators.

[JoshClose]

RFC 4180 says that the file format has line endings of CRLF, so technically the CSV files you have aren't valid. I updated it so it will use either CRLF, CR, or LF for line endings. I removed the option of specifying the line ending.