Bug in csv export - values created with commas if >3 digits before the decimal point

On the feeds page, there is a facility to download data in csv format.

It works fine for some data, but for numbers (floats?) greater than, or equal to 1000 in magnitude, an extra comma is inserted in the text e.g.:

1430178660,235.90
1430178720,239.85
1430178780,237.43
1430178840,1,216.43
1430178900,1,202.46
1430178960,560.09

 

... which is obviously not OK for a csv!

Cheers, Tim.

 

 

pb66's picture

Re: Bug in csv export - values created with commas if >3 digits before the decimal point

This has cropped up quite a few times, a workaround is to just concatenate vals 2 + 3. Far from ideal but it works.

Paul

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.