Page 1 of 1
File listing to CSV - wrong separator
Posted: Mon Aug 10, 2009 1:13 pm
by Peter2
I tried to export a filelist to CSV and got a comma , as separator. My Excel (2003, german) needs and saves "semicolon ;" as separator.
Is this a bug or is it dependent from language and country settings?
Peter
Re: File listing to CSV - wrong separator
Posted: Mon Aug 10, 2009 3:15 pm
by xnview
And CSV can't be imported if you select the good separator in Excel?
Re: File listing to CSV - wrong separator
Posted: Mon Aug 10, 2009 4:24 pm
by Peter2
Of source - selecting a separator does everything.
BUT: A doubleclick on a CSV (with ",") opens it with "all in one column"; a doubleclick on a semicolon-CSV opens it perfectly.
Peter
Re: File listing to CSV - wrong separator
Posted: Mon Aug 10, 2009 6:42 pm
by xnview
; is the default separator?
Re: File listing to CSV - wrong separator
Posted: Mon Aug 10, 2009 6:51 pm
by Peter2
xnview wrote:; is the default separator?
Yes - in my configuration. "," is very often used as decimal point (Germany, Austria), and therefore it can not be a separator (IMHO).
"Pi: 3,1415927"
Peter