Potash Valley

I've just learnt that the CSV format is culture specific. It means that depending on your regional settings Excel for instance will understant or not CSV files it opens.

For instance say I have a French version of Excel, if I open a "comma" separated value like a,b,c,d I would only have one column. But using the line a;b;c;d it will work. On an English version of Excel, it would be exactly the oposite.

This character (coma or semi-colon) is called the List Separator in your regional settings, and in .NET, to get this value we can use the CultureInfo.TextInfo ListSeparator property.