Convert scientific notation text to double?

[RyanHowell1]

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?

[DanPatterson_Retired]

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‍‍

or you you have some <null> records in the table/

float(!your_fieldname_here!)‍

may be the ticket if you just query for records that are not null... otherwise a code block will be needed