[CSV-171] Negative numeric values in the first column are always quoted in minimal mode

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.5
• Flags: Patch
• Assignee: Unassigned
• Reporter: Michael Graessle
• Created: 10/Feb/16 16:26
• Updated: 03/Sep/17 05:51
• Resolved: 31/Jul/16 07:23

Description

Negative Numeric values are always quoted in minimal mode if (and only if) they are in the first column.

i.e.
long,lat,data
"-92.222",43.333,3

Looking at the code, this is by design but seem to be for an unknown reason.

From v1.2 CSVPrinter line 230:

// TODO where did this rule come from?
if (newRecord && (c < '0' || (c > '9' && c < 'A') || (c > 'Z' && c < 'a') || (c > 'z'))) {
quote = true;
} else ...

I propose this rule to either be remove or at a minimum be changed to:
// TODO where did this rule come from?
if (newRecord && (c !='-' && c < '0' || (c > '9' && c < 'A') || (c > 'Z' && c < 'a') || (c > 'z'))) {
quote = true;
} else ...