CSV parser skips the empty cell by default

Question

Here is my csv

0|A0|B0||D0
1|A1|B1|C1|D1

Here is the csvParser i am using

 file.eachLine() { line ->
                if (!line.startsWith("0")) {
                    def field = line.tokenize("|")
                    lineCount++
                    closure(lineCount,field)
                }
                else{   
                }
            }

So in the first line of CSV it doesnt have C), How can I say read that empty line too.

tim_yates · Answer 1 · 2014-02-20T15:27:46.190

2

tokenize throws away empty tokens and returns a List<String>, try using split instead which returns a String[] and doesn't throw them away (see here for other differences)

Or use something like GroovyCSV and move the pain onto someone else's shoulders ;-)

edited Feb 20 '14 at 15:27

answered Feb 20 '14 at 15:22

tim_yates

167,322
27
342
338

score 1 · Accepted Answer · answered Feb 20 '14 at 15:32

1

this also does the trick:

file.splitEachLine( /\|/ ){ String[] parts ->
  if( '0' != parts[ 0 ] ){
    //do something with parts
  }else{}
}

God bless groovy! :)

answered Feb 20 '14 at 15:32

injecteer

20,038
4
45
89

CSV parser skips the empty cell by default

2 Answers2