Handling a tab seperated file (csv) with open csv?

Question

I've tried to create my reader like this:

CSVReader reader = new CSVReader(new FileReader("ping10102012.csv"), '\t');

int i=0;
while ( (nextLine = reader.readNext()) != null){
    System.out.println(nextLine[i]); // Debug only
}

And I'm having some issues with stuff. I'm only getting the first(column) values from my csv, and they're outputting pretty weird.

output:

I  D
2  7  2  2  2
2  4  6  9  4
...more like this

The columns are:

UnitId

Attempts

ACPower

etc. etc. Thanks for any help!

Thanks for any help! -> We cannot help without a question.. and some more explanation.. — Rohit Jain
– Rohit Jain, Commented Oct 11, 2012 at 15:32
@ Damien.Bell : Your file may not be tab separated? Please show actual file and actual code.. — Jayan
– Jayan, Commented Oct 11, 2012 at 15:39

Yogendra Singh · Accepted Answer · 2012-10-11 15:45:49Z

2

You are printing first column only as all the time as i=0 and there is no change in value assigned to i.

Try this:

         while ( (nextLine = reader.readNext()) != null){
            for(String value: nextLine){
               System.out.println(value); // Debug only
            }
        }

edited Oct 11, 2012 at 15:45

answered Oct 11, 2012 at 15:36

Yogendra Singh

34.5k7 gold badges66 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

A_Elric Over a year ago

Huge derp moment on that one. I'm still having a small issue where I'm getting an java.lang.ArrayIndexOutOfBoundsException: 1. I'm not entirely sure why that's happening

Yogendra Singh Over a year ago

Updated the answer to use for loop to print the column values. Its check the length internally. Hope that helps.

Collectives™ on Stack Overflow

Handling a tab seperated file (csv) with open csv?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related