CSV file datasource - string parser

Molot4inka · Post by **Molot4inka** » Fri Apr 17, 2009 8:23 pm

Hello, there is a bug in CsvHelper , i don't know why but you expect that csv (comma-separeted value) file will have ";" as delimeter, but csv uses comma "," as a delimeter, that is why it is called comma separated

becaouse of this bug when you retrieve data from csv you will get only one column (actually, all column will be merged in one with "_" betwen each cell vaue)

Post by **Ivan** » Mon Apr 20, 2009 5:31 am

Hello,

Molot4inka wrote:Hello, there is a bug in CsvHelper , i don't know why but you expect that csv (comma-separeted value) file will have ";" as delimeter, but csv uses comma "," as a delimeter, that is why it is called comma
separated becaouse of this bug when you retrieve data from csv you will get only one column (actually, all column will be merged in one with "_" betwen each cell vaue)

That is correct, the CSV is an abbreviation of "comma-separated value", but by default applications use the "list separator" character from the Windows Regional Settings.
In USA comma is the list separator, in many Eastern Europe countries the list separator is ";".

We have corrected the issue in the CsvHelper, now the column separator is taken from the System.Globalization.CultureInfo.CurrentCulture.TextInfo.ListSeparator.
Patch will be available in the next prerelease build from April, 27.

Thank you.