I have a particular layer where there are fileds that may not have a value. Viewing the table for this layer works fine. However, when attempting to export as a CSV the data does not output correctly. If a record has any fields with no value the data for that record is pushed to the columns to the right. For example if I have a table with 2 columns names ObjectID and CustomerNumber and the CustomerNumber is blank in one record, on export the ObjectID for that record would now be placed in the CustomerNumber field and the ObjectID field would be blank.
Is this a known issue and is there any resoulution besides making sure all fields have data?