Why does my CSVMapper put quotes around some Strings and not others?

Question

I have a class like this:

@JsonPropertyOrder({"Chilli"})
public interface ChilliReport {
    @JsonProperty("Chilli")
    String getChilli();

    @JsonProperty("Price")
    String getPrice();
}

// Then, I'll populate this with some values.


CsvMapper csvMapper = new CsvMapper();
CsvSchema schema = csvMapper.schemaFor(ChilliReport.class).withHeader();

String payload = csvMapper.writer(schema).writeValueAsString(reports);
System.out.println(payload);

Why is is that sometimes, the field "chilli" will be quoted while sometimes, it won't be?

Ex: Sometimes, my data looks like this:

"Chilli" "Price"

"Red",10

Other times like this: "Chilli" "Price"

Yellow,10

Btw, I changed the name of the class and actual names of the fields but that's the gist of my problem

score 0 · Answer 1 · answered Mar 08 '18 at 13:34

If fields contain a separator, they have to be quoted.

Some writers may quote all fields, some only those with separators inside (which actually keeps the file smaller).

So, you probably have something like this:

Chilli,Price
"Red,extra",10
Yellow,10

which gives the following table:

Chilli          Price
Red,extra       10
Yellow          10

Without the quotes you would get:

Chilli          Price
Red             extra       10
Yellow          10

Or maybe there are spaces in front or at the end of the string and the writer decides to quote those.

Why does my CSVMapper put quotes around some Strings and not others?

1 Answers1