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
File listing to CSV - wrong separator
Moderator: xnview
-
Peter2
- XnThusiast
- Posts: 1368
- Joined: Thu Nov 24, 2005 3:07 pm
- Location: CH
File listing to CSV - wrong separator
XnViewMP <Current version> German, XnConvert <Current version>, Win 10
-
xnview
- Author of XnView
- Posts: 47539
- Joined: Mon Oct 13, 2003 7:31 am
- Location: France
Re: File listing to CSV - wrong separator
And CSV can't be imported if you select the good separator in Excel?
Pierre.
-
Peter2
- XnThusiast
- Posts: 1368
- Joined: Thu Nov 24, 2005 3:07 pm
- Location: CH
Re: File listing to CSV - wrong separator
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
BUT: A doubleclick on a CSV (with ",") opens it with "all in one column"; a doubleclick on a semicolon-CSV opens it perfectly.
Peter
XnViewMP <Current version> German, XnConvert <Current version>, Win 10
-
xnview
- Author of XnView
- Posts: 47539
- Joined: Mon Oct 13, 2003 7:31 am
- Location: France
-
Peter2
- XnThusiast
- Posts: 1368
- Joined: Thu Nov 24, 2005 3:07 pm
- Location: CH
Re: File listing to CSV - wrong separator
Yes - in my configuration. "," is very often used as decimal point (Germany, Austria), and therefore it can not be a separator (IMHO).xnview wrote:; is the default separator?
"Pi: 3,1415927"
Peter
XnViewMP <Current version> German, XnConvert <Current version>, Win 10