CSV with comma or semicolon?

by

In Windows it is dependent on the “Regional and Language Options” customize screen where you find a List separator. This is the char Windows applications expect to be the CSV separator.

Of course this only has effect in Windows applications, for example Excel will not automatically split data into columns if the file is not using the above mentioned separator. All applications that use Windows regional settings will have this behavior.

If you are writing a program for Windows that will require importing the CSV in other applications and you know that the list separator set for your target machines is ,, then go for it, otherwise I prefer ; since it causes less problems with decimal points, digit grouping and does not appear in much text.

More Related Contents:

  1. Csv empty when trying to read it
  2. What’s the most robust way to efficiently parse CSV using awk?
  3. Dealing with commas in a CSV file
  4. Properly escape a double quote in CSV
  5. Is there a way to include commas in CSV columns without breaking the formatting?
  6. How to load jar dependenices in IPython Notebook
  7. csv to array in d3.js
  8. How to properly escape a double quote in CSV?
  9. Can you encode CR/LF in into CSV files?
  10. What MIME type should I use for CSV?
  11. Encoding Error in Panda read_csv [duplicate]
  12. Spark dataframe save in single file on hdfs location [duplicate]
  13. How to export a Hive table into a CSV file?
  14. Reading csv files with quoted fields containing embedded commas
  15. Parse a csv using awk and ignoring commas inside a field
  16. VBScript to loop through all files in a folder
  17. How to check encoding of a CSV file
  18. Sort CSV file by multiple columns using the “sort” command
  19. Export as csv in beeline hive
  20. UnicodeDecodeError: ‘charmap’ codec can’t decode byte 0x8d in position 7240: character maps to
  21. CodedUI test does not read data from CSV input file
  22. Can a CSV file have a comment?
  23. Write Spark dataframe as CSV with partitions
  24. Import CSV into google cloud datastore
  25. Reading CSV files using C#
  26. Trimming a huge (3.5 GB) csv file to read into R
  27. How to keep leading zeros in a column when reading CSV with Pandas?
  28. Writing Python lists to columns in csv
  29. Reading CSV files with MATLAB?
  30. regex to split line (csv file)

Leave a Comment