Bug
The Table To Table tool truncates text string values with leading zeroes (0) if the values are all integers.
| Bug ID Number | BUG-000156051 |
|---|---|
| Submitted | February 23, 2023 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS Pro |
| Version found | 3.0.3 |
| Operating System | N/A |
| Operating System Version | N/A |
| Status | As Designed |
Additional Information
Leading zeros are not supported in integer fields. To maintain leading zeros, the data must be loaded into a text field. Create a schema.ini file located in the same directory as the data. An example schema.ini for the text file included in the bug has the following contents: [test4.txt] ColNameHeader=True Format=CSVDelimited Col1=ID long Col2=ROLLNUM text width 15 Col3=STREET_DIR text width 1 Col4= STREET_NUM text width 30 Col5=CITY text width 30 Col6=UNIT_NUM text width 10 Col7=STREET1 text width 50 Col8=PROV_STATE_CODE text width 2 Col9=STREET2 text width 50 Col10=COUNTRY_CODE text width 3 Col11=POSTAL_ZIP text width 7 Basic documentation for the schema.ini file can be found in the following document. https://pro.arcgis.com/en/pro-app/3.0/help/data/tables/add-an-ascii-or-text-file-table.htmWorkaround
Enter a non-numeric value for at least one row in the ROLLNUM column and the tool brings all leading zeroes (0) correctly.
Steps to Reproduce
Bug ID: BUG-000156051
Software:
- ArcGIS Pro
Get notified when the status of a bug changes
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