Page 1 of 1
CSV file datasource - string parser
Posted: Fri Apr 17, 2009 8:23 pm
by Molot4inka
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)
CSV file datasource - string parser
Posted: Mon Apr 20, 2009 5:31 am
by Ivan
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.