Re: Special characters
- From: "Mr. T" <mail.mr.tcb@xxxxxxxxx>
- Date: Fri, 1 Sep 2006 19:48:21 +0200
Thanks for reply, jpdphd,
jpdphd wrote:
Mr T,
1. What DO you see when opening the file in Mac Excel?
The Mac is at the office so I can't tell you exact what it is I see, but I
guess I'm not far off when I say each character look something like this
"^¿?". This is special characters used with most font's I believe. I'll try
to drive by the office tomorrow and find out for sure if this is essential
information to find a solution.
2. What font are you using in Mac Excel?
I believe it's the standard font, which I believe is Arial 10 (like in Open
Office). But I'm sure the font is not the problem.
3. What do you see when opening the file in TextEdit (an application
that's on every Mac)?
I have to admit I didn't try that, and as said, unfortunately I don't have
the Mac where I am at the moment. But I have uploaded to the Internet a .csv
file including the characters that's making trouble. If you find the time,
please take a look at the file. In the web browser, everything looks like it
should (at least here it does), but if you save the file and open it in
Excel it's not the same.
Please see:
http://www.scantem.org/test.csv
And just to make sure it looks the same on your computer, here's a
screenshot of what it looks like here:
http://www.scantem.org/test.jpg
BTW, in HTML the character's are coded like this: æ ø å
Thanks again,
--
T.
jpdphd
Mr. T wrote:
We collect data from a form available on the Internet. This form
stores the submitted data into a .csv file. When we open this file
with Excel (Excel 2004 v. 11.1 for Mac) the European special
characters shows as different symbols. The characters display nicely
in the .csv file itself. When opening the same file on a PC running
Open Office there's an option to choose what character set we want
to use when importing the .csv file. Open Office suggest using
"Western Europe (Windows-1252/WinLatin 1)" which works perfectly.
But I need it to work with a Mac running OS-X. I can't find any
place to change the character set used when importing the file to
Excel running on Mac.
I don't know how this will display on everyone's screens, but here's
examples on some of the characters: "æ", "ø", "å". (There's only one
character within each "").
A solution to the problem, if no-one has any better suggestion, could
perhaps be to make a command to change whatever symbols (different
characters put together) that replaces the original character in all
of the document after it is imported. I have very little experience
using MS Office and don't know if that's even possible to make a
"command" like this, - or if it is possible, how to do it. This is a
document meant to be updated and imported daily.
Anyone have any suggestions on how to make it work? Or any ideas
where to ask?
Thanks,
--
T.
.
- Follow-Ups:
- Re: Special characters
- From: jpdphd
- Re: Special characters
- References:
- Special characters
- From: Mr. T
- Re: Special characters
- From: jpdphd
- Special characters
- Prev by Date: Re: Special characters
- Next by Date: Re: Special characters
- Previous by thread: Re: Special characters
- Next by thread: Re: Special characters
- Index(es):
Relevant Pages
|
