in reply to Re^4: XLSX to CSV with high ASCII characters
in thread XLSX to CSV with high ASCII characters

I cannot speak to your script as I don't know what's in the input file. But poj's script needs

use utf8;

at the top in order to tell Perl that the content of the source code is encoded as UTF-8. This causes the high character to be read correctly, and the remainder of the script to work as expected.

Note that you will have to consider whether your terminal is set to display UTF-8 when viewing the contents of the output file.

The way forward always starts with a minimal test.

Replies are listed 'Best First'.
Re^6: XLSX to CSV with high ASCII characters
by apu (Sexton) on Aug 26, 2017 at 21:57 UTC

    Adding "use utf8" to poj's script does help. I did try that with mine, but no help.

    My test input file is: 

    ID	Last	First	Pref
1	Peña	Nicolás	
2	Jones	John	Jack
3	D’Angelo	Michael	
4	Smith	Jane	Janey
    and the output is: 
    Pref,Last,Static,Text
Nicolás,Peña,Static,Text
Jack,Jones,Static,Text
Michael,"D’Angelo",Static,Text
Janey,Smith,Static,Text
[reply]

In Section Seekers of Perl Wisdom