What Encoding is Used for Exporting Files inTab Delimited Text (.txt) Format?

O

Optimalist

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I use Excel to create and manage a large database of information that I process and use in MATLAB (for running an experiment on medical reasoning errors). The problem is that any characters outside of the 7-bit ASCII character set appear differently in MATLAB than they do in Excel. For example, what appears as a degree symbol in Excel appears as an upside down exclamation point in MATLAB.

MATLAB file reading commands can be set to correctly interpret a variety of encodings (e.g., ISO-8859-1), so all I really need is to know what encoding scheme Excel 2008 for Mac uses when writing Tab Delimited Text (.txt) files.

Anyone's help would be greatly appreciated.
 
J

John_McGhie_[MVP]

Excel exports in "MacRoman" encoding on Macs, and "Windows-1252" on Windows.

http://en.wikipedia.org/wiki/Mac_OS_Roman

"Windows .csv" should give you 1252.

Cheers

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I use Excel to create and manage a large database of information that I
process and use in MATLAB (for running an experiment on medical reasoning
errors). The problem is that any characters outside of the 7-bit ASCII
character set appear differently in MATLAB than they do in Excel. For example,
what appears as a degree symbol in Excel appears as an upside down exclamation
point in MATLAB.

MATLAB file reading commands can be set to correctly interpret a variety of
encodings (e.g., ISO-8859-1), so all I really need is to know what encoding
scheme Excel 2008 for Mac uses when writing Tab Delimited Text (.txt) files.

Anyone's help would be greatly appreciated.
Click to expand...

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 
Top