topic Re: Convert scientific notation text to double? in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/convert-scientific-notation-text-to-double/m-p/587729#M25880 <HTML><HEAD></HEAD><BODY><P>You added a new double field to the table?</P><P>You tried... using the field calculator, python parser to convert from string to float/double? and it didn't work</P><PRE class="lia-code-sample line-numbers language-none"><CODE>float("9.99E-3") Out[1]: 0.00999<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><P>or you you have some &lt;null&gt; records in the table/</P><P></P><PRE class="lia-code-sample line-numbers language-none"><CODE>float<SPAN class="punctuation token">(</SPAN>!your_fieldname_here!<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><P>may be the ticket if you just query for records that are not null... otherwise a code block will be needed</P></BODY></HTML> Sun, 12 Dec 2021 01:15:09 GMT DanPatterson_Retired 2021-12-12T01:15:09Z Convert scientific notation text to double? https://community.esri.com/t5/arcgis-pro-questions/convert-scientific-notation-text-to-double/m-p/587728#M25879 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Anyone know of an easy way?</P></BODY></HTML> Thu, 07 Feb 2019 18:23:43 GMT https://community.esri.com/t5/arcgis-pro-questions/convert-scientific-notation-text-to-double/m-p/587728#M25879 RyanHowell1 2019-02-07T18:23:43Z Re: Convert scientific notation text to double? https://community.esri.com/t5/arcgis-pro-questions/convert-scientific-notation-text-to-double/m-p/587729#M25880 <HTML><HEAD></HEAD><BODY><P>You added a new double field to the table?</P><P>You tried... using the field calculator, python parser to convert from string to float/double? and it didn't work</P><PRE class="lia-code-sample line-numbers language-none"><CODE>float("9.99E-3") Out[1]: 0.00999<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><P>or you you have some &lt;null&gt; records in the table/</P><P></P><PRE class="lia-code-sample line-numbers language-none"><CODE>float<SPAN class="punctuation token">(</SPAN>!your_fieldname_here!<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><P>may be the ticket if you just query for records that are not null... otherwise a code block will be needed</P></BODY></HTML> Sun, 12 Dec 2021 01:15:09 GMT https://community.esri.com/t5/arcgis-pro-questions/convert-scientific-notation-text-to-double/m-p/587729#M25880 DanPatterson_Retired 2021-12-12T01:15:09Z