topic Re: CSV Data - ArcMap 10.2 - working with Exponential/Mathematical Numbers in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/csv-data-arcmap-10-2-working-with-exponential/m-p/162654#M5505 <HTML><HEAD></HEAD><BODY><P>If you open the CSV file in excel, a schema.ini is created initialy. You can edit this to define the data types. The file schema.ini is usually with a "hidden' attribute so you may not see it unless your folder settings allows it.</P></BODY></HTML> Fri, 09 Jan 2015 03:34:19 GMT MikeCusi 2015-01-09T03:34:19Z CSV Data - ArcMap 10.2 - working with Exponential/Mathematical Numbers https://community.esri.com/t5/geoprocessing-questions/csv-data-arcmap-10-2-working-with-exponential/m-p/162651#M5502 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>This is doing my head in...</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I have a simple .CSV file: X (easting), Y (Northing), DataValue (e.g. 1.52E-26, 1.20E-21, 8.69E-22, etc..)</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>If I drag this file from Catalog it gives the DataValue field "double" format and makes all values zero.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I've tried using the excel to table tool, I've tried saving as a .txt file...no luck.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Opening this .csv file in MapInfo Professional works perfectly....i.e. holds all the mathematical values.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Why is ArcMap so difficult when it comes to a simple .csv file ??</P><P>Am I doing something wrong?</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>help?</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>thanks</P></BODY></HTML> Fri, 09 Jan 2015 02:12:24 GMT https://community.esri.com/t5/geoprocessing-questions/csv-data-arcmap-10-2-working-with-exponential/m-p/162651#M5502 timdunlevie 2015-01-09T02:12:24Z Re: CSV Data - ArcMap 10.2 - working with Exponential/Mathematical Numbers https://community.esri.com/t5/geoprocessing-questions/csv-data-arcmap-10-2-working-with-exponential/m-p/162652#M5503 <HTML><HEAD></HEAD><BODY><P>A schema.ini hopefully will make it easier. <A href="http://msdn.microsoft.com/en-us/library/ms709353%28v=vs.85%29.aspx" title="http://msdn.microsoft.com/en-us/library/ms709353%28v=vs.85%29.aspx">Schema.ini File (Text File Driver)</A> </P></BODY></HTML> Fri, 09 Jan 2015 02:47:47 GMT https://community.esri.com/t5/geoprocessing-questions/csv-data-arcmap-10-2-working-with-exponential/m-p/162652#M5503 MikeCusi 2015-01-09T02:47:47Z Re: CSV Data - ArcMap 10.2 - working with Exponential/Mathematical Numbers https://community.esri.com/t5/geoprocessing-questions/csv-data-arcmap-10-2-working-with-exponential/m-p/162653#M5504 <HTML><HEAD></HEAD><BODY><P>Thanks Mike….much appreciated.</P><P></P><P>Seems like a lot of fiddling around just to view/interrogate data in ArcMap ??</P><P></P><P>Tim</P></BODY></HTML> Fri, 09 Jan 2015 03:25:52 GMT https://community.esri.com/t5/geoprocessing-questions/csv-data-arcmap-10-2-working-with-exponential/m-p/162653#M5504 timdunlevie 2015-01-09T03:25:52Z Re: CSV Data - ArcMap 10.2 - working with Exponential/Mathematical Numbers https://community.esri.com/t5/geoprocessing-questions/csv-data-arcmap-10-2-working-with-exponential/m-p/162654#M5505 <HTML><HEAD></HEAD><BODY><P>If you open the CSV file in excel, a schema.ini is created initialy. You can edit this to define the data types. The file schema.ini is usually with a "hidden' attribute so you may not see it unless your folder settings allows it.</P></BODY></HTML> Fri, 09 Jan 2015 03:34:19 GMT https://community.esri.com/t5/geoprocessing-questions/csv-data-arcmap-10-2-working-with-exponential/m-p/162654#M5505 MikeCusi 2015-01-09T03:34:19Z Re: CSV Data - ArcMap 10.2 - working with Exponential/Mathematical Numbers https://community.esri.com/t5/geoprocessing-questions/csv-data-arcmap-10-2-working-with-exponential/m-p/162655#M5506 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P>I have a similar but perhaps reverse problem. I have some polygon data in a .gdb file which has centroid Long Lat in decimal degrees eg 151.2348, -33.98114. When I export to a shape file, the .dbf file component of that has truncations of the Long Lat eg 151.235, -33.9811. I then want to pull that data back into ArcGIS after doing some manipulaton in Excel.The Lat truncation is not much of a problem at the scale I am working at (a 2 km zone around a central point) but the Long shows up as dots arranged as vertical lines.</P><P>Has anyone else experienced this and found a solution?</P><P></P><P>Barbara</P></BODY></HTML> Mon, 12 Jan 2015 00:48:56 GMT https://community.esri.com/t5/geoprocessing-questions/csv-data-arcmap-10-2-working-with-exponential/m-p/162655#M5506 BarbaraMoloney 2015-01-12T00:48:56Z