1753631 Members
5608 Online
108798 Solutions
New Discussion

Perl module

 
ivy1234
Frequent Advisor

Perl module

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"
1 REPLY 1
Jose Mosquera
Honored Contributor

Re: Perl module

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.