nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Converting String Data to Double or Precision

NMDC2015COMMERCIAL

Dear All,

Please can anyone tell me how i can convert an attribute field in strings to to Double or Precision Numeric.

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.

Thanks

Find more posts tagged with

Accepted answers

All comments

AdrianWelsh

Was this issue ever resolved?

MarkEllis

Second the above suggestions. To troubleshoot further (if the calculation starts, but fails), strip any extra characters from the text string source field. A single extra space or letter can bail the calculation when it reaches that record.

NeilAyres

"..getting this error message"

Sorry, but what error message?

NMDC2015COMMERCIAL

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

NMDC2015COMMERCIAL

thanks Mitch.

i have tried this method field calculate with the above steps before now but i keep getting this error message.

AdrianWelsh

I second what Mitch has said. Also, what type of data are you trying to make? A shapefile? Geodatabase?

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

MitchHolley1

1.) Add a field to the table that is a double or precision data type

2.) Field Calculate the newly added field to the 'string' field values

I'm assuming you're using ArcGIS...

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.