I have a table, coming from Excel, with 21K rows, which is partially filled with numbers, and partially with the
"" value from excel, which is displayed as
<Null> in the table view.
I need to use the number values to display as graduated colors, which ArgMap won't allow me, as they are stored in a string column.
I tried converting those values into Double()'s using the field calculator as is mentioned in this article from ESRI: https://support.esri.com/en/technical-article/000002287
The code I used from the article is:
Dim String, Check String = [String field name] Check = IsNumeric(String) If Check = True then Output = CDbl(String) else Output = null End if
Output in the second field.
Where I clicked on the appropriate field name to insert the name behind String.
This however produces a column full of
<NULL> values, without any error message.