apple,"wild cherry",peach pear,plum,"apricot" mango,payaya,guava "orange, Valencia", lemon, lime """extra virgin"" olive", palm, dateUsually 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.
|
|
available on the web at: |
http://mindprod.com/jgloss/csv.html |
optional Replicator mirror
|
J:\mindprod\jgloss\csv.html | |
![]() |
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 :
| |
| Blog | Canadian
Mind
Products
IP:[65.110.21.43] Your face IP:[107.22.127.92] |
|
| Feedback | You are visitor number 70,729. | |