R
robreil
Im in a fix.
I have to do a csv export of our database table which equates to 9000
rows by abou 40 columns.
Some of these columns host full html data.
The problem is that while managing this data while integrating a large
amount of rows into the csv we sometimes have to sort by column. We
have done this both by using the A/Z sort button short cut, and by
clicking the upper left box where all cells get highlighted, clicking
Data, then Sort, and choosing appropriate columns to sort by. Sometimes
we hide columns in order to manage 40 columns of data. However from time
to time in a manner we can not yet duplicate or determine (though we
have a suspision that it is hidden data) we find that data that was was
not sorted even though we choose to have all fields sorted becomes
disassociated with it's respective row and the data ends up being
corrupted. Though this is not to say that we are sure that hidding data
is even relevent.
Has anyone seen this behavior?
Is there a fix, or switch, or different tool we should be using to do
mass sorting, and resorting without fear of loosing data integrity?
I have to do a csv export of our database table which equates to 9000
rows by abou 40 columns.
Some of these columns host full html data.
The problem is that while managing this data while integrating a large
amount of rows into the csv we sometimes have to sort by column. We
have done this both by using the A/Z sort button short cut, and by
clicking the upper left box where all cells get highlighted, clicking
Data, then Sort, and choosing appropriate columns to sort by. Sometimes
we hide columns in order to manage 40 columns of data. However from time
to time in a manner we can not yet duplicate or determine (though we
have a suspision that it is hidden data) we find that data that was was
not sorted even though we choose to have all fields sorted becomes
disassociated with it's respective row and the data ends up being
corrupted. Though this is not to say that we are sure that hidding data
is even relevent.
Has anyone seen this behavior?
Is there a fix, or switch, or different tool we should be using to do
mass sorting, and resorting without fear of loosing data integrity?