Perl module

ivy1234 — Thu, 27 Jan 2011 01:28:12 GMT

I use the below perl program csv2xls.pl can convert a csv to xls file , it works fine , but I found that it only work for English characters , I tried to use it to convert a csv file ( with japanese characters ) , it does not work , I also tried the perl "unicode_utf16_japan.pl" , it also did not work I want to find a tools / method ( perl or any other tools ) to convert it in my other unix-like server ( other distro ) not only for hp unix , is there any tools / method suit for it ? Thx.

http://search.cpan.org/dist/Spreadsh...code_8859_7.pl

I want to find a tools / method to convert it in my other unix-like server ( other distro ) not only for hp unix , is there any tools / method suit for it ? Thx.

Sample of csv file
==============
Name , staff no , xxx ,xxx , Salary
Lashi , SF1007 , SG , G , 242000

Where xxx is Japanese

Error when use the perl module
======================
"Text::CSV_XS parse() failed on argument: Name , staff no ,噱笭,禱?? , Salary"

Re: Perl module

Jose Mosquera — Thu, 27 Jan 2011 09:29:13 GMT

Hi,

I have never done this but try sending the final output file as an email. We will try set the charset utf-8 in the MIME header file:
#echo "MIME-Version: 1.0" > outputfile
#echo "Content-Type: text/plain; charset=UTF-8\n\n" >> outputfile
#cat your_file.csv >> outputfile
#sendmail your_email@domain.com < outputfile

Please try it and tell me something...

Rgds.

topic Perl module in Operating System - HP-UX

Perl module

Re: Perl module