I have a point file with 237k points, and I want to convert a text field containing scientific notation values (i.e 9.99E-3) to a double value field. I'm having issues finding a tool or code to do this.
Anyone know of an easy way?
You added a new double field to the table?
You tried... using the field calculator, python parser to convert from string to float/double? and it didn't work
float("9.99E-3") Out[1]: 0.00999<SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN></SPAN>
or you you have some <null> records in the table/
float<SPAN class="punctuation token">(</SPAN>!your_fieldname_here!<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN></SPAN>
may be the ticket if you just query for records that are not null... otherwise a code block will be needed
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
