Export to Excel (Comma delimeted) creates new columns with commas in a text field
Posted: May 24th, 2018, 5:02 am
Dear Support,
My CSPRO app has a number of test fields that enumerators may sometime enter data and use commas. For example an item Food, asking for food produced; Enumerators may fill Maize, Beans, Kales under the one text alpha field (Food) separating the stated items with commas. When it comes to exporting the data to an excel file using comma delimited, the data is exported but new columns are created due to the commas in the test field instead of having all the items in one column (Food).
Is there a way I can go around this?
My CSPRO app has a number of test fields that enumerators may sometime enter data and use commas. For example an item Food, asking for food produced; Enumerators may fill Maize, Beans, Kales under the one text alpha field (Food) separating the stated items with commas. When it comes to exporting the data to an excel file using comma delimited, the data is exported but new columns are created due to the commas in the test field instead of having all the items in one column (Food).
Is there a way I can go around this?