皆様へ、
文字列の属性フィールドをDoubleまたはPrecision Numericに変換する方法を教えていただけますか。
Excelファイルからデータをインポートしましたが、列が数値であるにもかかわらず文字列として読み込まれました。この文字列の問題のため、これらの列をkriging操作でzとして使用したいため、kriging操作を実行できません。
ありがとうございます
Was this issue ever resolved?
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.
"..getting this error message"
Sorry, but what error message?
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
thanks Mitch.
i have tried this method field calculate with the above steps before now but i keep getting this error message.
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
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...
サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
