ignoring commas when reading from csv files in java

Question

How do I store a string containing quotes or commas in to a csv file and retrieve it later without having my output split up?

See http://stackoverflow.com/questions/101100/csv-api-for-java — Adam, Feb 13 '11 at 16:41

score 3 · Answer 1 · edited May 23 '17 at 12:13

3

Best thing is to use api's meant for reading/writing csv's like opencsv

edited May 23 '17 at 12:13

Community

answered Feb 13 '11 at 16:41

Aravind Yarram

score 0 · Answer 2 · answered Feb 13 '11 at 16:40

0

Don't parse it yourself, use a library like this to do so: http://ostermiller.org/utils/CSV.html

This way, you don't need to worry about double quotes or commas in the string, etc.

answered Feb 13 '11 at 16:40

limc

score 0 · Answer 3 · edited Oct 07 '21 at 06:31

0

Values are quoted, so any comma inside a pair of quotes is ignored.

Quotes are escaped by doubling. So any sequence of two quotes inside a value is replaced by a single quote.

You can read the details in RFC 4180.

edited Oct 07 '21 at 06:31

Community

answered Feb 13 '11 at 17:15

erickson

3 Answers3