Writing to CSV through java

Question

When writing a column name into a CSV file through java the space between two words in a column comes up as double quotation marks...

eg. test_data[0][36] = "True Accept"; displays as True" Accept in the csv file..

Any ideas how this can be fixed?

Here is the code:

private void writeToCSV() throws IOException {
   CSVWriter writer = new CSVWriter(new FileWriter("list_of_churners.csv"),',',' '); 
   String [] data = new String[40]; 
   for(int i=0;i<341;i++)
   { 
      for(int k=0;k<40;k++)
      {      
         data[k] = test_data[i][k]; 
      }
      writer.writeNext(data); 
   }
   writer.close()
}

EDIT: Here is the solution:

CSVWriter writer = new CSVWriter(new FileWriter("list_of_churners.csv"),',','\t ');

Changing space ' ' to '\t' fixes the problem.

What library are you using to write the CSV file? Also, post your code please. — Perception
– Perception, Commented Apr 24, 2012 at 12:53
private void writeToCSV() throws IOException{ CSVWriter writer = new CSVWriter(new FileWriter("list_of_churners.csv"),',',' '); String [] data = new String[40]; for(int i=0;i<341;i++){ for(int k=0;k<40;k++){ data[k]=test_data[i][k]; } writer.writeNext(data); } writer.close(); } — user1353707
– user1353707, Commented Apr 24, 2012 at 13:20
You can (and should) edit you original question instead of posting the code in a comment. I did that for you. For future reference, check out the formatting FAQs stackoverflow.com/editing-help and the general FAQs at stackoverflow.com/faq — Stefan
– Stefan, Commented Apr 24, 2012 at 13:55

Kai · Accepted Answer · 2012-04-24 13:27:49Z

1

Use a framework for writing and reading CSV files. I recommend OpenCSV.

answered Apr 24, 2012 at 13:27

Kai

39.8k14 gold badges92 silver badges106 bronze badges

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

Collectives™ on Stack Overflow

Writing to CSV through java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related