Unwanted double quotes in generated csv file

java csv file-io opencsv supercsv
Edward picture Edward · Dec 20, 2012 · Viewed 43k times · Source

I have created a CSV file using the Java code below:

String csv = rs.getString("UPLOAD_FOLDER_PATH")+".csv";
CSVWriter writer = new CSVWriter(new FileWriter(csv));
String [] filevalues = new String[filevaluesarray.size()];

filevalues=filevaluesarray.toArray(filevalues);

writer.writeNext(filevalues);

writer.close();

I am getting the CSV file, but the content of the file has unwanted double quotes.

Eg. "ABC","123","KDNJ"

I don't get from where these double quotes are added.

Answer

Shamis Shukoor picture Shamis Shukoor · Dec 20, 2012

This worked for me

CSVWriter writer = 
    new CSVWriter(new FileWriter(csv), ',', CSVWriter.NO_QUOTE_CHARACTER);

See the CSVWriter javadoc

Related questions

Read CSV file column by column

I want to read specific columns from a multi column csv file and print those columns in other csv file using Java. Any help please? Following is my code to print each token line by line..But I am looking …

Read More
Java: CSV File Easy Read/Write

I'm working on a program that requires quick access to a CSV comma-delimited spreadsheet file. So far I've been able to read from it easily using a BufferedReader. However, now I want to be able to edit the data it …

Read More
Java - Writing strings to a CSV file

I am trying to write data to a csv file with java, however when I try opening the produced file with excel I am getting an error saying the file is corrupt. Upon opening the file in notepad it looks …

Read More