Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

Re^10: how to output file in Unicode

by anakin30 (Acolyte)
on Aug 28, 2012 at 06:21 UTC ( #990145=note: print w/replies, xml ) Need Help??

in reply to Re^9: how to output file in Unicode
in thread how to output file in Unicode

this "Björn" appear only if i open the csv output file using microsoft excel

using notepad or Editplus (editor) it looks good.

Replies are listed 'Best First'.
Re^11: how to output file in Unicode
by Anonymous Monk on Aug 28, 2012 at 07:11 UTC
    What encoding does the "microsoft excel" program think the file is in?
Re^11: how to output file in Unicode
by anakin30 (Acolyte) on Aug 28, 2012 at 07:17 UTC

    i changed it once, but it doesn't work out, i still seeing the character as "Björn".

    i don't know why? but how to ensure the output was delivered in UTF-8 encoded? is there any way i can prove?

    why the string still displayed as "Björn" even though i set the output to encoding(UTF-8), as below line

    open (OUTPUT, ">:encoding(UTF-8)",$outputfile) or die "Cannot open filename for input: $!";

      when i open the generated csv output file in excel, and when i click "save as" i see the file recognized as a *.csv file.

      Any other i can use to check the file being open on which format or encoding??

        Use the "file -> open" dialog. There you can specify the encoding for text files in Excel.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://990145]
[Corion]: A good daystart everybody!

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (6)
As of 2018-01-23 08:36 GMT
Find Nodes?
    Voting Booth?
    How did you see in the new year?

    Results (241 votes). Check out past polls.