How to remove comma in a string while writing into csv file with comma separator in java

Question

I am working on a java project. I have to retain a comma separator from my parsed string "," and still should be able to write into csv file. currently my csv file values are separated with comma (",") in it . because of this , if I have comma in a string its divided into two string on csv

ex:

input string : "Animal","Stand","Earth","owner,jeff"

my current output : (which is incorrect )

Expected output :

I have the logic in place for writing things into csv , I just need the string to be manipulated in a such way it should in corporate the ",". how to achieve this ?

here is my code:

private static void Addrow(String Animals, String Posture, String planet,String owner) throws IOException {
        String csv_write = csv_file_to_write;
        CSVWriter writer = new CSVWriter(new FileWriter(csv_write , true));

            String [] record = (Animals+","+Posture+","+planet+","+owner).split(",");

        writer.writeNext(record);

        writer.close();

    }

Does this solve your problem? Is there a way to include commas in CSV columns without breaking the formatting? — sn-
– sn-, Commented Nov 11, 2020 at 9:22
@asn21 i have read that post there they talk about enclosing the string with " " but in my case entire string looks something like this "Animal","'Stand'","Earth","Owner","Jeff" how to enclose this with " "? — Divakar R
– Divakar R, Commented Nov 11, 2020 at 9:25
I was able to remove the quotes by CSVWriter.NO_QUOTE_CHARACTER but now i am not able to add quotes around the exact string i want — Divakar R
– Divakar R, Commented Nov 11, 2020 at 9:45

Chintamani Satavalekar · Accepted Answer · 2020-11-11 08:40:13Z

1

One way to tackle that would be to split it at \",\" and for the first entry remove the " at the beginning and for the last entry remove the " at the end. You will then be left with the list of strings Animal, Stand, Earth, Owner,Jeff and so on...

answered Nov 11, 2020 at 8:40

Chintamani Satavalekar

215 bronze badges

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

Collectives™ on Stack Overflow

How to remove comma in a string while writing into csv file with comma separator in java

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related