CODEWITHSUNDEEP
javacsv
Sachin Singh
Sachin Singh

Reputation: 749

reading CSV file till particular column numbers

I am reading csv file method as under -

public ArrayList<String> fileRead(File f) throws IOException {
        FileReader fr = new FileReader(f);
        BufferedReader br = new BufferedReader(fr);
        ArrayList<String> CSVData = new ArrayList<String>();
        String text;
        try {
            while ((text = br.readLine()) != null) {
                CSVData.add(text);
                log.debug(text);
            }
            log.info(f + ": Read successfully");

            br.close();
            fr.close();
        } catch (IOException e) {
            log.error("Error in reading file " + e.getMessage());
        }
        return CSVData;
    }

but I want to read file till defined column number e.g. till 20th column, but if in between I will found empty cell for some column then as above code it will exit on (text = br.readLine()) != null , so finally my question is how to read CSV file till particular columns either its empty cell or whatever it should read till those column and break point for moving next line should be that column example 20th column ,

Thank in advance for help and support

Upvotes: 0

Views: 1089

Answers (1)

Jeronimo Backes
Jeronimo Backes

Reputation: 6289

You should use uniVocity-parsers' column selection feature to process your file.

Here's an example:

CsvParserSettings settings = new CsvParserSettings();
parserSettings.selectFields("Foo", "Bar", "Blah");
// or if your file does not have a row with column headers, you can use indexes:
parserSettings.selectIndexes(4, 20, 2);
CsvParser parser = new CsvParser(settings);
List<String[]> allRows = parser.parseAll(new FileReader(f));

Disclosure: I am the author of this library. It's open-source and free (Apache V2.0 license).

Do NOT try to parse a CSV by yourself. There are many intricacies there. For example, using code such as the one you pasted:

while ((text = br.readLine()) != null) {

Will break as soon as your CSV has values that contain newline characters.

Upvotes: 1

Related Questions