Would it be possible for Statplanet to support field values enclosed in quotes, according to RFC 4180? See http://en.wikipedia.org/wiki/Comma-separated_values#Toward_standardization.
I have several indicator names containing comma's. Currently it is not possible to use these names in the data file. (Also it is currently impossible to use the PHP function fputcsv to create data files, as this requires an enclosure character.)
Hi,
StatPlanet does support the use of comma's in indicator names and descriptions. There is no need to enclose it in quotes - just insert them as you normally would. I hope that helps. If it doesn't work, could you provide an example text which does not display? Please note though that it assumes you are using Excel, which automatically puts quotations when saving as a CSV file. For example:
my, indicator
Is saved by Excel as:
"my, indicator"
Best,
Frank
Hi Frank,
Sorry for the late reply. The data files are generated separate from Statplanet. Here is an example:
Kind regards,
Gaele
Hi Gaele,
It looks like indicator and unit names are always in double quotation marks. The double quotation marks should only be used if there is a comma in the indicator unit name, i.e.
Indicator name without comma
or
"Indicator name, with comma"
I hope that resolves the issue.
Best,
Frank
Hmm. This means when generating the data files I would have to inspect every indicator name, and depending on it containing a comma surround it by double quotation marks or not. So I come back to my original question:
Would it be possible for Statplanet to support field values enclosed in quotes, according to RFC 4180? This means "Any field may be quoted (with double quotes)" - independent of field contents.
Hi Gaele,
Because StatPlanet is (normally) Excel-based it has been designed to follow the Excel CSV format. Allowing any field to be quoted could be implemented for the next version, however, it may take a few months. If it is required ASAP, it could be done as a custom / paid development and I can send a quote.
Best,
Frank