Use comma decimal delimiter in a delimited text file

Summary

Most European operating systems' regional settings use a comma for the decimal delimiter, for example: 12,34 instead of 12.34. This can cause problems for comma-delimited text tables.

Procedure

1. Edit the text file using a semicolon as the column delimiter. The following example demonstrates a text table that uses a comma for the decimal delimiter and a semicolon for the column delimiter.
   

   LongInt;Float;Double;Decimal 
   123456789;123,50;123,56;123,56
   123456789;1236,67;1234576,65;112345,56 

   
   
2. Modify the schema.ini file to specify the semicolon delimiter as shown below. 'Table1.txt' is the name of a semicolon-delimited text file.
   
   

   [Table1.txt]
   Format=Delimited(;) 

   
   
   

   Note:
   For more information concerning delimited text files in ArcMap and ArcCatalog, refer to the ArcGIS Desktop Help topic About tabular data sources.