AnsweredAssumed Answered

Spreadsheet data import: Convert 'String' to 'Double' and also '#DIV/0!' to 'Null' (instead of '0's)

Question asked by GoldenJiang on Jan 5, 2016
Latest reply on Jan 6, 2016 by GSCUser85

I am having a problem importing excel spreadsheet data into ArcGIS and join with my existing attribute table.


I have tried saving the data as text files or csv. and imported again, but the program still recognise the column data format as 'String', maybe because there are too many text boxes '#DIV/0!'.


The goal is to convert 'String' to 'Double' and importantly: the blank '#DIV/0!' to 'Null' (instead of '0's).


I have tried creating a new column as 'Double' format and then using the Field Calculator to run '[Field]/1', but it turns out 'failure during processing'.


Please let me know if there is any solution.