Re: CSVReader

From:

Roedy Green <see_website@mindprod.com.invalid>

Newsgroups:

comp.lang.java.programmer

Date:

Mon, 11 Feb 2008 22:19:55 GMT

Message-ID:

<2gi1r3tqbelfkabgp9om7dd75dd3ach01d@4ax.com>

On Mon, 11 Feb 2008 12:17:51 +0100, "Christoph Keller"
<chkeller@bluewin.ch> wrote, quoted or indirectly quoted someone who
said :

It works fine for s1, s2, but s3 is null. How would the get() method read
from the next line?

get() returns null for EOL.

Typical use:

CSVReader csv = new CSVReader( new FileReader( "currency.csv" ),
                               ',',
                               '\"',
                               false /* multiline */,
                               true /* trim */ );
try
   {
   while ( true )
      {
      // treat all fields as Strings
      String[] fields = csv.getAllFieldsInLine();
      ...
      }
   }
catch ( EOFException e )
   {
   }
csv.close();

or

CSVReader t = new CSVReader( new FileReader( "currency.csv" ) );
try
   {
   while ( true )
      {
      String countryCode = t.get();
      double exchange = t.getDouble();
      t.skip(1);// ignore field
      int decimalPlaces = t.getInt();
      t.skipToNextLine();
      ...
      }// end while
   }
catch ( EOFException e )
   {
   t.close();
   }

There two examples are now included in the download.
--

Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com