AnsweredAssumed Answered

CSV Data - ArcMap 10.2 - working with Exponential/Mathematical Numbers

Question asked by timdunlevie on Jan 8, 2015
Latest reply on Jan 11, 2015 by moloneb

Hi all,

 

This is doing my head in...

 

I have a simple .CSV file: X (easting), Y (Northing), DataValue (e.g. 1.52E-26, 1.20E-21, 8.69E-22, etc..)

 

If I drag this file from Catalog it gives the DataValue field "double" format and makes all values zero.

 

I've tried using the excel to table tool, I've tried saving as a .txt file...no luck.

 

Opening this .csv file in MapInfo Professional works perfectly....i.e. holds all the mathematical values.

 

Why is ArcMap so difficult when it comes to a simple .csv file ??

Am I doing something wrong?

 

help?

 

thanks

Outcomes