|
Hi, When I export CE data in csv, the fields (in columns) don't appear by alphabetical order, which makes it very difficult to navigate the file. Can something be done about this? Thanks! Florence |
|
Dear Florence, So far this is not possible to change. The order of columns is the order to the fields on the survey. If you need the fields to be ordered alphabetically there is a very simple solution in Excel! Just open the CSV exported from Collect Earth in Excel (remember these are CSV delimited by commas, which sometimes in Excel does not look right - the columns are mixed - you then need to use the Data-> From text see LINK) Then go to the Data tab and click on the short menu icon, then on the dialog choose sort options and there pick the option "Sort left to right". Finally you chose that you want to use the row 1 (the attribute names row) to sort by. When you click OK the columns will rearrange following the alphabetical order of the attribute names.
|
|
Hi OF, Thanks but actually, the order of the fields in my case is NOT the order in the survey. I have fields that are one after another in the survey that have many columns between them. I wonder if the order in the csv is not chronological, i.e., based on when the fields were entered in the survey. I can add an example... Cheers, Florence |
