com.logicaldoc.util.csv

Class CSVFileReader

java.lang.Object

com.logicaldoc.util.csv.CSVFile

com.logicaldoc.util.csv.CSVFileReader

public class CSVFileReader
extends CSVFile

CSVFileReader is a class derived from CSVFile used to parse an existing CSV file.

Adapted from a C++ original that is Copyright (C) 1999 Lucent Technologies.
Excerpted from 'The Practice of Programming' by Brian Kernighan and Rob Pike.

Included by permission of the Addison-Wesley web site, which says: "You may use this code for any purpose, as long as you leave the copyright notice and book citation attached".

Version:

%I%, %G%

Author:

Brian Kernighan and Rob Pike (C++ original), Ian F. Darwin (translation into Java and removal of I/O), Ben Ballard (rewrote handleQuotedField to handle double quotes and for readability), Fabrizio Fazzino (added integration with CSVFile, handling of variable textQualifier and Vector with explicit String type)

Field Summary

Fields

Modifier and Type	Field and Description
protected BufferedReader	in The buffered reader linked to the CSV file to be read.

Fields inherited from class com.logicaldoc.util.csv.CSVFile

DEFAULT_FIELD_SEPARATOR, DEFAULT_TEXT_QUALIFIER, fieldSeparator, textQualifier

Constructor Summary

Constructors

Constructor and Description
CSVFileReader(String inputFileName) CSVFileReader constructor just need the name of the existing CSV file that will be read.
CSVFileReader(String inputFileName, char sep) CSVFileReader constructor with a given field separator.
CSVFileReader(String inputFileName, char sep, char qual) CSVFileReader constructor with given field separator and text qualifier.

Method Summary

Methods

Modifier and Type	Method and Description
void	close() Close the input CSV file.
protected int	handlePlainField(String s, StringBuffer sb, int i) Handles an unquoted field.
protected int	handleQuotedField(String s, StringBuffer sb, int i) Handles a quoted field.
Vector<String>	readFields() Split the next line of the input CSV file into fields.

Methods inherited from class com.logicaldoc.util.csv.CSVFile

getFieldSeparator, getTextQualifier, setFieldSeparator, setTextQualifier

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

in

protected BufferedReader in

The buffered reader linked to the CSV file to be read.

Constructor Detail

CSVFileReader

public CSVFileReader(String inputFileName)
              throws FileNotFoundException,
                     UnsupportedEncodingException

CSVFileReader constructor just need the name of the existing CSV file that will be read.

Parameters:

inputFileName - The name of the CSV file to be opened for reading

Throws:

FileNotFoundException - If the file to be read does not exist

UnsupportedEncodingException

CSVFileReader

public CSVFileReader(String inputFileName,
             char sep)
              throws FileNotFoundException,
                     UnsupportedEncodingException

CSVFileReader constructor with a given field separator.

Parameters:

inputFileName - The name of the CSV file to be opened for reading

sep - The field separator to be used; overwrites the default one

Throws:

FileNotFoundException - If the file to be read does not exist

UnsupportedEncodingException

CSVFileReader

public CSVFileReader(String inputFileName,
             char sep,
             char qual)
              throws FileNotFoundException,
                     UnsupportedEncodingException

CSVFileReader constructor with given field separator and text qualifier.

Parameters:

inputFileName - The name of the CSV file to be opened for reading

sep - The field separator to be used; overwrites the default one

qual - The text qualifier to be used; overwrites the default one

Throws:

FileNotFoundException - If the file to be read does not exist

UnsupportedEncodingException

Method Detail

readFields

public Vector<String> readFields()
                          throws IOException

Split the next line of the input CSV file into fields.

This is currently the most important function of the package.

Returns:

Vector of strings containing each field from the next line of the file

Throws:

IOException - If an error occurs while reading the new line from the file

close

public void close()
           throws IOException

Close the input CSV file.

Throws:

IOException - If an error occurs while closing the file

handleQuotedField

protected int handleQuotedField(String s,
                    StringBuffer sb,
                    int i)

Handles a quoted field.

Returns:

index of next separator

handlePlainField

protected int handlePlainField(String s,
                   StringBuffer sb,
                   int i)

Handles an unquoted field.

Returns:

index of next separator