laptop and a wrench

Bogue

The Table To Table tool truncates text string values with leading zeroes (0) if the values are all integers.

Dernière publication: April 6, 2023 ArcGIS Pro
Numéro d’ID de bogue BUG-000156051
EnvoiFebruary 23, 2023
Dernière modificationJune 5, 2024
S’applique àArcGIS Pro
Version trouvée3.0.3
Système d’exploitationN/A
Version du système d’exploitationN/A
StatutAs Designed

Informations supplémentaires

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.htm

Solution de contournement

Enter a non-numeric value for at least one row in the ROLLNUM column and the tool brings all leading zeroes (0) correctly.

Étapes pour reproduire

ID de bogue: BUG-000156051

Logiciel:

  • ArcGIS Pro

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement