Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

String containing comma inputting in to the csv file

Tags:

java

csv

I am trying to input in to the csv file.
My input is as shown below
String string="hi,this is user";
but when i am inputing in to the csv file the comma is taken as delimiter and it is written in two cells. "hi" in one cell and "this is user" in another cell.
But i want the whole string to be in one cell.
How can i achieve this.
Please help me.

FileWriter writer = new FileWriter("D:/Workspace/Sample2.csv");
PrintWriter out = new PrintWriter(writer);

String names="[hasds,jash.jahd,jash]";
    out.append(names);
    out.flush();
}
like image 370
user2243525 Avatar asked Apr 19 '13 11:04

user2243525


1 Answers

Since you're writing a csv file, with comma delimiter, and your text happens to have a comma in it as well, you need to wrap your text within double quotes.

String names = "\"hi,this is user\"";

Note that to wrap your text within double quotes, you need to escape the double quotes as well!

Update:- A sample code snippet to wrap your string within double quotes.

public static void main(String[] args) {

    String test = "abcd";
    System.out.println(test); // prints abcd
    test = appendDQ(test);
    System.out.println(test); // prints "abcd"

}

private static String appendDQ(String str) {
    return "\"" + str + "\"";
}
like image 72
Rahul Avatar answered Oct 16 '22 15:10

Rahul