I am editing attribute tables of multiple shapefiles for a future project. I need the field data types to be very specific and uniform among all the shapefiles. I am running into the problem that the majority of these shapefiles's attribute tables are all different in terms of field name and field data type.
I have been adding a new field, then using field calculator to copy the data from the old field column into the new one. However, one field (StationID) has been giving me trouble because copying station id with letters and numbers (example 113a) will not copy into a float in the new added field. And that is fine, I can manually fix that and include the information in a separate Notes column, but not when there over 1,000 entries in which this occurs.
Is there any command, or tool or function, that could "easily" change the field data type from string/text to float?