How to import multiline csv files?

Question

I got a file in this format.

"abc";"def";"ghi
asdasd
asdasd
asd
asd
aas
d
"

Now i want to import it with Java. Does anyone know a library that support this kind of import?

Answer 1

Perhaps JavaCSV.

Answer 2

Maybe Commons CSV, even if it is a beta project (but works quite good)

Answer 3

If you want to do is just import that kind of file, I think any of the 3 or 4 main Java CSV libraries should do the job.

But you can take a look at this post if you want to have an overview on the many features and differences between SuperCSV, OpenCSV and JavaCSV. I already used JavaCSV to write the kind of file you want to read and it was perfect.

Note : not sure but I heard that only SuperCSV is still maintained

Answer 4

There are a number of CSV utilities out there, and the best I've come across is OsterMiller. The API is good, it can handle very large datasets gracefully, as well as being aware of the odd CSV that MS Excel generates for some kinds of data.

Answer 5

There is an additional problem which I didn't realized earlier. I think this is why the libraries don't work.

there are double quotes inside the csv "fields", like that:

one recordset:

"abc";"def";"ghi
asdasd
asdasd
asdasd "asd"
asd
aas
d
"