Group Abstract Group Abstract

Message Boards Message Boards

Exploring 10,934 Wolfram Demonstrations

Posted 9 years ago
Attachments:
POSTED BY: Erik Mahieu
4 Replies
Posted 9 years ago

Downloaded the .csv file. Opened in Excel, and saw every entry compressed into the same column:

enter image description here

I have come across this problem before. Its due to my Windows 10 having the list separator character specified as semicolon (Settings -> Region & Language). So I edited the .csv file to be independent of local PC settings, assuming comma as the field separator. The edited file is attached.

enter image description here

Attachments:
POSTED BY: Hans Milton
POSTED BY: EDITORIAL BOARD
Posted 9 years ago

Thanks, Hans, i had not noticed this problem since I am using Numbers on a Mac computer. Interestingly, on the Mac, the comma separated acts like the semicolon separated in Windows! So, its nice to have both files!

semicolon separated in Numbers/Mac

comma separated in Numbers/Mac

POSTED BY: Erik Mahieu

Very nice! thanks for sharing!

POSTED BY: Sander Huisman
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard