topic Re: Converting String Data to Double or Precision in Ocean Science Questions https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528666#M70 <HTML><HEAD></HEAD><BODY><P>i have used this VB script .....CDbl(String) but i keep getting this error message and no data was found in the new field created. please a quick help will be appreciated. thanks</P></BODY></HTML> Wed, 28 Sep 2016 05:06:56 GMT NMDC2015COMMERCIAL 2016-09-28T05:06:56Z Converting String Data to Double or Precision https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528662#M66 <P>Dear All,</P> <P>&nbsp;</P> <P>Please can anyone tell me how i can convert an attribute field in strings to to Double or Precision Numeric.</P> <P>i have imported the data from an excel file and it has read the column as String even though the columns are numeric values due to this string issue i can not perform the kriging operation because i want to use these columns as my z in the kriging operation.</P> <P>Thanks</P> Tue, 24 Nov 2020 19:10:42 GMT https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528662#M66 NMDC2015COMMERCIAL 2020-11-24T19:10:42Z Re: Converting String Data to Double or Precision https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528663#M67 <HTML><HEAD></HEAD><BODY><P>1.) Add a field to the table that is a double or precision data type</P><P>2.) Field Calculate the newly added field to the 'string' field values</P><P></P><P>I'm assuming you're using ArcGIS...</P></BODY></HTML> Tue, 27 Sep 2016 13:56:10 GMT https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528663#M67 MitchHolley1 2016-09-27T13:56:10Z Re: Converting String Data to Double or Precision https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528664#M68 <HTML><HEAD></HEAD><BODY><P>I second what Mitch has said. Also, what type of data are you trying to make? A shapefile? Geodatabase?</P><P></P><P>Another thing you can do is, in Excel, be sure the entire data column is set to be numeric. Format the cells for the entire column and select Number for the category</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/235114_pastedImage_1.png" /></P></BODY></HTML> Tue, 27 Sep 2016 14:05:14 GMT https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528664#M68 AdrianWelsh 2016-09-27T14:05:14Z Re: Converting String Data to Double or Precision https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528665#M69 <HTML><HEAD></HEAD><BODY><P>thanks Mitch.</P><P>i have tried this method field calculate with the above steps before now but i keep getting this error message.&nbsp;</P></BODY></HTML> Wed, 28 Sep 2016 04:57:14 GMT https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528665#M69 NMDC2015COMMERCIAL 2016-09-28T04:57:14Z Re: Converting String Data to Double or Precision https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528666#M70 <HTML><HEAD></HEAD><BODY><P>i have used this VB script .....CDbl(String) but i keep getting this error message and no data was found in the new field created. please a quick help will be appreciated. thanks</P></BODY></HTML> Wed, 28 Sep 2016 05:06:56 GMT https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528666#M70 NMDC2015COMMERCIAL 2016-09-28T05:06:56Z Re: Converting String Data to Double or Precision https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528667#M71 <HTML><HEAD></HEAD><BODY><P><EM style="background-color: #ffffff;">"..getting this error message"</EM></P><P><SPAN style="background-color: #ffffff;">Sorry, but what error message?</SPAN></P></BODY></HTML> Wed, 28 Sep 2016 06:51:10 GMT https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528667#M71 NeilAyres 2016-09-28T06:51:10Z Re: Converting String Data to Double or Precision https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528668#M72 <HTML><HEAD></HEAD><BODY><P>i guess i was getting that because i did not convert the file to goedatabase file. so for the VB script to work i have to convert first to geodatabse so its all ok now.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 28 Sep 2016 11:31:54 GMT https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528668#M72 NMDC2015COMMERCIAL 2016-09-28T11:31:54Z Re: Converting String Data to Double or Precision https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528669#M73 <HTML><HEAD></HEAD><BODY><P>Second the above suggestions. To troubleshoot further (if the calculation starts, but fails), strip any extra characters from the text string source field. &nbsp;A single extra space or letter can bail the calculation when it reaches that record.</P></BODY></HTML> Thu, 02 Feb 2017 20:30:16 GMT https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528669#M73 MarkEllis 2017-02-02T20:30:16Z Re: Converting String Data to Double or Precision https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528670#M74 <HTML><HEAD></HEAD><BODY><P>Was this issue ever resolved?</P></BODY></HTML> Thu, 02 Feb 2017 20:50:16 GMT https://community.esri.com/t5/ocean-science-questions/converting-string-data-to-double-or-precision/m-p/528670#M74 AdrianWelsh 2017-02-02T20:50:16Z