Examples of smilehouse.util.csv.CSVReader

smilehouse.util.csv.CSVReader

This class is used for reading CSV files. It implements the flavor of CSV used by MS Excel for example, and can also be used for parsing tab-delimited and other similar files. CSV's consist of Records which contain Fields. This class can handle data encoded in the following manner:

The data consists of one or more Records, each ending with an end-of-line character. The last end-of-line is optional unless the last Record is empty.
Each Record consists of one or more Fields separated by delimiter characters.
Empty Record consists of one Field containing an empty string.
Each Field may be quoted or unquoted.
Unquoted Fields are literal strings, and may not contain special characters.
Quoted Fields are surrounded by quote characters, and may contain any characters.
Any quote characters within quoted fields are doubled.
Special characters are quote, end-of-line and delimiter.

The class also implements line precise error reporting on csv format errors.
This parser is lenient by default and the previously described format has been implemented with the exception that :

unquoted Fields can contain quotes but a quote cannot be the first character of the field.

        
        StringBuffer XMLresult = new StringBuffer("");
       


        // Current version of CSVParser, does not use csvLineSeparatorChar parameter
        CSVReader csvReader = new CSVReader(
            new StringReader(data),
            csvRecordSeparatorChar,
            csvQuoteChar);


        try {
            csvResult = csvReader.records();
        } catch(CSVFormatException e) {
            logger.logMessage("Invalid data detected while reading CSV table, aborting", this, MessageLogger.ERROR);
            PipeComponentUtils.failTransfer();
        } catch(IOException e) {
            logger.logMessage("IOException while reading CSV table, aborting", this, MessageLogger.ERROR);

Examples of smilehouse.util.csv.CSVReader

Related Classes of smilehouse.util.csv.CSVReader