PROBLEM
Float values from text files are truncated to whole numbers in ArcMap
Description
When viewing an ASCII CSV, TXT, or TAB file in an application other than ArcGIS, the file displays values such as:
X,Y
-124,34
-123.45,32.789
When opened in ArcGIS, the values displayed in these items are truncated to:
X,Y
-124,34
-123,32
Cause
Tools that access ASCII files in ArcGIS, such as the 'Add XY Data' command, use a Microsoft driver to read text files. By default, this driver only scans the first 75 records of the text file to determine the data type of each field. If the first 75 records are all integers, then the entire field will be assumed to be integer, even though subsequent records may be float or double.
Solution or Workaround
Modify the schema.ini file, which gets created in the same directory as the text file and defines how the Microsoft driver interprets the text file.Instructions for modifying this file are available in the ArcGIS Online Help under Contents tab > ArcCatalog > Exploring the values in a table > About tabular data sources > Accessing delimited text file data. A link is provided to a Microsoft Web site where a search can be done on 'schema.ini' to access more detailed information.
- The following example of schema.ini shows how to force the Microsoft text file driver to read the first 500 lines of a text file called MYDATA.TXT.
[myData.txt]
Format=CSVDelimited
ColNameHeader=True
MaxScanRows=500
Article ID: 000006097
- ArcMap
Receive notifications and find solutions for new or common issues
Get summarized answers and video solutions from our new AI chatbot.
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App