How to skip headers in csv file when headers exists

Question

I am using apache-common-csv to import data from the CSV file and I would like to skip headers in the first line. What is important, the file sometimes can contain headers but sometimes not. I have an implementation like below but the result not satisfying me, because when the file is without headers the first line is cutting.

CSVFormat.DEFAULT
        .withDelimiter(';')
        .withHeader(HEADERS)
        .withSkipHeaderRecord()
        .parse(InputStreamReadersource.inputStream)

I would form a String by combining the header words and compare if the first line of csv is same as this String. Won't it solve your issue ? — Trishul Singh Choudhary, Feb 16 '20 at 18:12
you're right. I did a filter to compare two strings and it's works. Thanks — db9, Feb 16 '20 at 19:27

score 0 · Answer 1 · answered Feb 16 '20 at 18:19

0

I think this could help you.

CSVFormat.RFC4180
         .withFirstRecordAsHeader()
         .withDelimiter(';').parse(InputStreamReadersource.inputStream);

Here is the reference on Commons CSV user guide https://commons.apache.org/proper/commons-csv/user-guide.html

answered Feb 16 '20 at 18:19

John Kangari

31
3
10

2

This doesn't answer the question, since it *always* skips the first record, even if it isn't a header. – avandeursen Dec 11 '21 at 16:47

How to skip headers in csv file when headers exists

1 Answers1