in reply to Problem with special characters in a csv file

One possible solution is to open CSV something like this:
my $csv = Text::CSV_XS->new ({'always_quote' => 1, 'eol' => "\n", 'binary' => 1, });
That will allow "funny characters" directly in the CSV file.

If you are determined to change the characters to entities, you could do it something like this:

$string=~s/[\x7f-\xff\&]/"&#".ord($1).";"/ge;

Replies are listed 'Best First'.
Re^2: Problem with special characters in a csv file
by shilpam (Sexton) on Jul 22, 2004 at 08:54 UTC
    Thanks a lot! The solution worked!!!
Re^2: Problem with special characters in a csv file
by Anonymous Monk on Apr 16, 2011 at 08:10 UTC
    I had the same problem with csv files, but i solved it with saving my Excel file to txt and then just replacing (with replace all)tabs with comas, and I used the txt file for the print merge.