I am having a big issues with CSV files I need to open. They are in Japanese. They do not show up correctly at all. I have tried to do this in Excel for OSX and still not happening. This should really work. I have tried a number of fonts and encoding as well.
Link to the sample file did not work. I will email it to anyone that wants it.
Thanks
iMac (27-inch, Late 2012), OS X Mountain Lion (10.8.5)
tomfromtooele wrote:
I have tried a number of fonts and encoding as well.
Fonts are irrelevant, but did you specifically try the encodings utf-8 and utf-16?
If you are using Excel, the best place to ask your questions is in the forum devoted to that MS stuff:
Open the file in Text Edit and look at the file. Are the delimiter REALLY commas? Often the crux of the problem centers around the localization the files was created in and/or the localization where you are reading the file. Numbers does not appear to honor that in all cases.
PS If problems persist, you can send me the file (tom at bluesky dot org).
Me too. look in my profile for my email address
If the csv file is not encoded in UTF-8, which seems to be the case, you need to either a) convert the file to UTF-8 or b) specify the current encoding constant in com.apple.TextEncoding extended attribute of the file.
For a), you may use, for instance, TextEdit.app to open the csv file in question and save it as in UTF-8 by setting the application's preferences accordingly. For b), you may use xattr(1) command to set the extended attribute accordingly.
Regards,
H
Numbers CSV language issues. Whats wrong?
