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
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.