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 stackoverflow.com/questions/101100/csv-api-for-java

Adam
– Adam

2011-02-13 16:41:38 +00:00
Commented Feb 13, 2011 at 16:41 — Adam
– Adam, Commented Feb 13, 2011 at 16:41

Community · Accepted Answer · 2017-05-23 12:13:16Z

3

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

Can you recommend a Java library for reading (and possibly writing) CSV files?

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered Feb 13, 2011 at 16:41

Aravind Yarram

80.5k49 gold badges239 silver badges335 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

limc · Accepted Answer · 2011-02-13 16:40:12Z

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, 2011 at 16:40

limc

40.3k22 gold badges106 silver badges145 bronze badges

Comments

Community · Accepted Answer · 2021-10-07 06:31:44Z

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 7, 2021 at 6:31

CommunityBot

11 silver badge

answered Feb 13, 2011 at 17:15

erickson

271k59 gold badges406 silver badges502 bronze badges

Collectives™ on Stack Overflow

ignoring commas when reading from csv files in java

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related