Currently Being ModeratedMay 6, 2011 7:34 AM (in response to Jaxanne)
What is the problem ?
As it was explained hjerte many times,
if your system uses the period as decimal separator, the file name must end with ".csv" and the values must be separated by commas
if your system uses the comma as decimal separator, the file name must end with ".csv" and the values must be separated by semi-colons
There is an annoying problem: from time to time, users receive files whose name ends with ".xls" which are in fact csv ones,
others receive files whose name ends with ".csv" which are in fact html tables or other formats.
When you get a wrong behavior, drag and drop the document's icon on the application TextEdit.
Doing that, you will quickly know which is the structure of your document.
If it's really a csv one with the 'wrong' separator, the best scheme is to change temporarily your system setting so that it matches the separators used.
If it use commas, set the system to country/region : USA
If it use semi-colons, set the system to country/region :France.
Numbers will run according to this setting so it will open the doc correctly.
Save as is.
Reset the system to your standard setting and open the new file in Numbers.
This time it will be OK. Maybe you will have some problems with numbers using thousand separators or with dates.
In other cases,you may send the file(s) to my mailbox.
I will look at its internal structure. With a bit of luck, I have a script ready to decipher it.
In other cases, I will do my best to write a new script.
If you must send a file, click my blue name to get my address.
Yvan KOENIG (VALLAURIS, France) 6 mai 2011 16:34:20To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.6.7)
Currently Being ModeratedMay 6, 2011 8:04 AM (in response to KOENIG Yvan)
You are most patient and very kind Yvan. I had read earlier postings but did get confused but am now trying the solutions you suggest. I will let you know how I get on and hope I don't need to bother you with my file. Bonne fin de l'après-midi....
Currently Being ModeratedMay 6, 2011 8:24 AM (in response to Jaxanne)
Thanks for the feedback.
Now it's my turn to ask.
At this time I can't reach my iMac backups so I would be glad if the askers which sent me the two files which I will name may send them one more time.
I wish to concatenate several scripts in a single one but to be able to do that I must have these file to see what may be used as a signature.
Yvan KOENIG (VALLAURIS, France) 6 mai 2011 17:24:40To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.6.7)
Currently Being ModeratedMay 9, 2012 1:19 AM (in response to Jaxanne)
I think the easiest way is to open the .csv-file in a text-editor and find and replace the seperator.
I am from Germany and I had a .csv-file with comma as seperator, but since I have my system set to german system, my numbers won't accept the comma as seperator. So I had to replace the commas by semicolons.
I opened the file in TextEdit and found and replaced all commas by semikolons. Now numbers opens the file correctly.
Currently Being ModeratedMay 9, 2012 1:35 AM (in response to harrharr)
Oh before I forget it ...... how and where can I request the option in numbers '09 to choose the seperator manually when importing .csv-files ? Or is this already on a list they are working on ?
Ok, found the answer ...... option to request features in numbers is going to "numbers > Provide Numbers Feedback".