Export: Remove thousands separator when outputting CSV?

joshlk · February 20, 2014 11:28AM

I do a lot of manipulation using CSV and must output data set tables from Omniscope as CSV for re-use by external programs. Some of these external programs do not support quoting numeric fields in CSV whenever there's a comma separator added into the numeric value in the field. e.g. CSV output:

foo,boo,"10,000",16

When outputting CSVs from Omniscope, could there please be a option which removes the thousand separator in numbers so that quoting the numbers to enclose the separator commas within a comma de-limited file is not necessary?

Thanks

paola · February 24, 2014 5:39AM

Thousands separator can be removed either in the DataManager space, by using the Field Organiser block (open the field options, then un-tick the separator box).
Same can be achieved using the Data>Manage fields > [Field x] Options
On export, the formatting without commas should be preserved.

joshlk · May 8, 2015 4:02AM

Such a process can be tedious when you have many (e.g. 20 fields)

Welcome!

Categories

Ideas Parade

Tagged