Currently Being ModeratedApr 22, 2011 2:04 AM (in response to Serge Dufort1)
The support of CSV files was described here many times.
If the decimal separator in use on the system is the period, Numbers requires the original CSV format : Comma Separated Values.
If the decimal separator in use on the system is the comma, Numbers requires the alternate CSV format : Semi-colon Separated Values.
Given what you wrote, you are trying to import datas from a file using the original CSV format and the decimal comma.
I know that some experts wrote Python filters to treat such case but I have no reference available at this time.
If you send a sample file to my mailbox, I will try to write an AppleScript deciphering it.
But as I often wrote, CSV is really the worst format ever invented. Why aren't you asking the document's author to use Tab Separated Values format ?
Click my blue name to get my address.
Yvan KOENIG (VALLAURIS, France) vendredi 22 avril 2011 11:04:21
Currently Being ModeratedApr 22, 2011 5:52 AM (in response to KOENIG Yvan)
Thanks Yvan, a patch was provided to change the way the file was encoded with. I can now use ";" instead of ",", it makes more sense when decimal value are being inserted in the CSV file.
Currently Being ModeratedApr 23, 2011 1:58 AM (in response to Serge Dufort1)
The standard CSV format may be used when the decimal separator is the comma.
It requires that numerical values are enclosed between quotes.
It's what Numbers '08 was deciphering.
Alas, at this time, Claris which is a 100% Apple subsidiary delivered Bentoy (no typo here, the "y" is deliberate) which used the alternate format.
I filed a report and Apple changed the app behavior/requirements when they designed Numbers '09.
There is no perfect solace with this ridiculous format.
In lieu of editing your encoding scheme from comma to semi-colon, it would have been more efficient to replace the comma separator by the TAB, name the exported files as wxyz.txt and you would have a clean answer.
Yvan KOENIG (VALLAURIS, France) samedi 23 avril 2011 10:58:05