English

How To: 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

Use a semicolon, instead of a comma to delimit table columns.

  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.