Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

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.


Comment on Re^10: how to output file in Unicode
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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://990145]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (11)
As of 2015-07-08 00:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (93 votes), past polls