How to skip lines in input file with apache commons csv. In my file first few lines are garbage useful meta-information like date, etc. Can’t find any options for this.
JavaScript
x
private void parse() throws Exception {
Iterable<CSVRecord> records = CSVFormat.EXCEL
.withQuote('"').withDelimiter(';').parse(new FileReader("example.csv"));
for (CSVRecord csvRecord : records) {
//do something
}
}
Advertisement
Answer
Use FileReader.readLine()
before starting the for-loop
.
Your example:
JavaScript
private void parse() throws Exception {
FileReader reader = new FileReader("example.csv");
reader.readLine(); // Read the first/current line.
Iterable <CSVRecord> records = CSVFormat.EXCEL.withQuote('"').withDelimiter(';').parse(reader);
for (CSVRecord csvRecord: records) {
// do something
}
}