Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

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]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (4)
As of 2017-11-18 08:55 GMT
Find Nodes?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:

    Results (277 votes). Check out past polls.