Scott Conway

It won't be that difficult. For simple apps it can be a direct replacement. There are a couple of examples at https://opencsv.sourceforge.net/#configuration or you can clone the repo and look at the unit tests. But basically replace your CSVReader constructor with CSVReader reader = new CSVReaderBuilder(new FileReader("yourfile.csv")) .withCSVParser(new CSVParserBuilder() .build()) .build(); and the CSVWriter constructor call with ICSVWriter csvWriter = new CSVWriterBuilder(new FileWriter("yourfile.csv"))...

The default constructor for CSVWriter and CSVReader are inconsistent

Hello Jon - I am marking this one as won't fix as it is a bug that is not a bug but is really a bug.... This situation was created in the early days because of conflicting requests/requirements/bug entries in the early days and the issue arose that any change to correct one issue would cause others to raise bugs because their code, coded the way it worked previously, broke. People complain to me about being too stuck on backwards compatibility but when you get to a point where you cannot upgrade...

Oh Guido, Guido, Guido, Guido, Guido. You are going back to stating something that is NOT in the specification Rule 6 specifies CRLF, comma or doublequote. it does not state CR, LF, or CRLF. It is not just because of the limited capacity, though I thank you for actually acknowledging that, it is the years before I created the RFC4180Parser that I got literal hate mail that opencsv, which existed BEFORE the RFC4180 specification did not support the RFC4180 specification and constantly showing how...

When in doubt - quotes all about :D

Yes - in cases like this my advise is to just turn quotes on all the time. It is still legal csv and that protects you from oddities in character sets from older operating systems or non ascii character sets.

And for further clarification on a large number of OS and/or programming languages LF is used as a new line not CRLF. But I have yet to identify one that solely uses CR.

So where in the RFC 4180 spec states that fields with escape characters must be enclosed with quotes? Rule 6 is states only CRLF Fields containing line breaks (CRLF), double quotes, and commas should be enclosed in double-quotes. For example: "aaa","b CRLF bb","ccc" CRLF zzz,yyy,xxx where CR = %x0D ;as per section 6.1 of RFC 2234 [2] LF = %x0A ;as per section 6.1 of RFC 2234 [2] CRLF = CR LF ;as per section 6.1 of RFC 2234 [2] In cases like this I recommend setting the applyQuotesToAll to true instead...