Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Problem with special characters in a csv file

by matija (Priest)
on Jul 22, 2004 at 05:17 UTC ( #376474=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://376474]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (7)
As of 2017-11-18 14:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:













    Results (277 votes). Check out past polls.

    Notices?