Version: 2.0.0_devel (using unspecified) OS: Windows 32-Bit When using the option "custom delimiter" with comma as delimiter, the following problems appear: , 1234, will be read as nan because of the leading space ,12/24/09,123 will cause 123 to be read as nan because of the /. If it is instead a : or letters, 123 is read as 123.
I see this with 1.7.1 from debian lenny and 1.9.1 from SVN, too. I have to pipe my csv files through sed 's/, /,/' to get them to read.
At least part of the problem is that by default the '/' character is defined as a comment indicator, meaning that everything following it on a line will be treated as a comment (and so not read). Removing the '/' character from the list of comment indicators in the configure dialog fixes this part of the problem.
There are no remaining problems once '/' is removed as a comment indicator.
In order to correctly read the entries that appear as: , 1234, the custom delimiters should be change from "," to " ," i.e. add a space