Re^2: Writing a .txt file for import in Excel with UTF-8 BOM

[bradcathey]

Yes, I did learn that you can import the file into Excel with UTF-8 as an option and all is fine but trying to make the experience for the client a little smoother. I guess MS doesn't take UTF-8 straight out of the box. Strange.

I have used Excel::Template in the past, but for my purposes it would be complicated to set up and looking for something quick. But nothing is quick when programming, right.

Thanks!

[poj]

If you want to open the file in Excel with a double mouse click rather than using the text import wizard, File::BOM will work or just add another print line to your script.

#!perl
use strict;
use utf8;
#use File::BOM(); 
#open my $fh, '>:utf8 :via(File::BOM)','output_with_bom.csv' 
#      or die "$!";

open my $fh, '>:utf8','output_with_bom.csv' or die "$!";
print $fh chr(0xFEFF); # U+FEFF is EF BB BF as utf-8
print $fh $_ for <DATA>;
close $fh;

__DATA__
a,1
b,2
©,3
®,4

poj