topic Re: How to change field from string to double? in Data Management Questions

How to change field from string to double?

MikeWissner — Wed, 03 Aug 2011 14:32:56 GMT

I did a simple percentage calculation in an Excel sheet before adding the data to arc. When I bring the table into arc the two fields with the percentages calculated are identified as string. I need them as double so that I can display symbology through their quantities. I tried to go back into excel and change the format of the columns and this did not work. Please help!

Re: How to change field from string to double?

DanEvans — Thu, 04 Aug 2011 11:57:25 GMT

Well you can't change an already existing field's type but you can specify what data type you want each field to be when you import the Excel sheet into your geodatabase (or .dbf file). Right-click on the field in the field map and go to properties and you can choose the type. ArcGIS will try to convert the values for you if it can but I think maybe in your case you have percentage symbols (%) in there too, which is why it brought them in as strings at first. I think if that's the case and you try to convert to integer or double you'll just get zeros or <null>.

Probably the best thing to do now you've already got the table in ArcGIS is to add a new double field and use the field calculator to strip any non-numerical characters before copying them into the new field.

Hope that helps
Dan

Re: How to change field from string to double?

MikeWissner — Sun, 07 Aug 2011 20:29:35 GMT

Thanks Dan.

Yes, the problem was the presence of non-numerical characters. Once removed, the field type remained double once brought in from excel. Success!