CSV : Java Glossary

CSV
CSV (Comma Separated Value). A file of ASCII (American Standard Code for Information Interchange) fields separated by commas. Microsoft Word, Microsoft Excel, and SQL (Standard Query Language) can often import some variant on this format.
apple,"wild cherry",peach
pear,plum,"apricot"
mango,payaya,guava
"orange, Valencia",  lemon, lime
"""extra virgin"" olive", palm, date
Usually fields containing embedded spaces or commas are contained in " marks, but there are other conventions. Quotes (") inside quoted fields are doubled. Europeans often use ; and Perl aficionados use tab to separate fields instead of commas. Sybase SQL import uses ' instead of ".

I wrote CSVReader and CSVWriter which are available with complete Java source. They are full featured and configurable. As well as the read/write classes there are 20 utilities to let you do such thisgs as sort, align, pack, etc. with the library or with the sample utilities. I find these utilities useful for massaging data into tidied form, e.g. by screenscaping, without having to write any Java code.

For simple key=value you might use the built-in Properties mechanism instead. Unfortunately, it has a complex system of encoding awkward characters incompatible with CSV.

Advantages

Disdvantages


CMP homejump to top You can get the freshest copy of this page from: or possibly from your local J: drive (Java virtual drive/mindprod.com website mirror)
http://mindprod.com/jgloss/csv.html J:\mindprod\jgloss\csv.html
logofeedback Please email your feedback for publication, letters to the editor, errors, omissions, typos, formatting errors, ambiguities, unclear wording, broken/redirected link reports, suggestions to improve this page or comments to Roedy Green : feedback email If you want your message kept confidential, not considered for posting, please explicitly specify that.
mindprod.com IP:[65.110.21.43]
view BlogYour face IP:[38.107.179.214]
You are visitor number 60,756.