Escape special meaning of # (double quote) in Apache commons-csv

Question

HELLO printing in a double quote in .tsv file because of '#' like "#HELLO". I want to remove the double quotes when it writes to .tsv

current output -> "#HELLO"

expected output -> #HELLO

try ( CSVPrinter printer = new CSVPrinter(new FileWriter("data.tsv"), CSVFormat.TDF))
{
   printer.printRecord("#HELLO");

}catch (IOException ex) {
    ex.printStackTrace();
}

talex · Answer 1 · 2022-09-30T13:06:28.380

1

You need to adjust format

CSVFormat.Builder.create(CSVFormat.TDF)
    .withQuoteMode(QuoteMode.MINIMAL)
    .build();

edited Sep 30 '22 at 13:06

answered Sep 30 '22 at 08:23

talex

17,973
3
29
66

Not working deprecated ... – shreeshailaya vitkar Sep 30 '22 at 11:54
@shreeshailayavitkar I changed to non deprecated version. – talex Sep 30 '22 at 13:08

score 1 · Accepted Answer · answered Oct 03 '22 at 12:44

1

I changed the version of CSVCommons to 1.8 and below code is working for me...

CSVPrinter printer = new CSVPrinter(new FileWriter("data.tsv"), CSVFormat.TDF.withHeader("#default1", "default2").withEscape('"').withQuoteMode(QuoteMode.NONE)

answered Oct 03 '22 at 12:44

shreeshailaya vitkar

43
6

Escape special meaning of # (double quote) in Apache commons-csv

2 Answers2