Wierd Characters when importing CSV file

  • Thread starter Thread starter Ben Childs
  • Start date Start date
B

Ben Childs

Hi,

I am having a wierd problem with Excel 2003 Proffesional. I have written
a program in C# (VS.NET 2002) which I use to export some data in csv
format. When I subsequently import this data into excel there is an
additional character that appears everytime I have the character 'µ' in
the data file. If I open up the file in notepad, the additional
character is not there, so it seems that Excel is adding this character
for some reason.

So in notepad i see "epPdnr11.26µm" but in excel i see "epPdnr11.26µm".
I have attached an example file.

Ideally I would like Excel to not display this character. But I have no
idea where it is coming from.

Thanks for any help.

-Ben Childs
 
Ben,

Ah, but that  is there. It's code is 194. There's one in front of each of
the µ characters. NotePad is ignoring it.
 
Ok, I guess the StreamWriter from C# must be outputting that character
for some reason. I'll have to look into it.

Thanks

-Ben
 
Well now I'm making some progress. I have outputted the data in unicode
format now and it seems to have stopped output of that extra character.
However, now Excel doesn't recognize the commas in the file.

Is there some way to get Excel to open unicode text files and use the
commas appropriately?

I have attached the unicode version of the file.

Thanks

-Ben Childs
 
Back
Top