Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

Re^4: Read text file - Encoding problem?

by poj (Monsignor)
on Mar 17, 2013 at 12:50 UTC ( #1023905=note: print w/replies, xml ) Need Help??

in reply to Re^3: Read text file - Encoding problem?
in thread Read text file - Encoding problem?

The 'd' is 0d the hex code for a carriage return. This node has the details Why chomp() is not considering carriage-return

  • Comment on Re^4: Read text file - Encoding problem?

Replies are listed 'Best First'.
Re^5: Read text file - Encoding problem?
by better (Acolyte) on Mar 17, 2013 at 15:14 UTC

    Thanks for this link!

    Is it correct, that this Carriage return (cr) is obviously not removed by chomp? And that this could be the reason, why the regex (including cr) can not be matched to the array elements of read_dir (which have no cr)?

    Well, I will try to remove cr by defining $/ = "\r\n" and I will see if the script is running


    ...and later:

    It works!!!

    After parsing the csv file and writing the entries of the first coloumn into a text file, stripping of the carriage return. My main script "search and copy files" works.

    Thanks to all monks, who helped me to find enlightenment ;-)

    I'm feeling much better now

    And here is the code:

    #! /usr/local/bin/perl # #script opens and parses CSV files #removes carriage return #and writes all into a new text file # #tested: --ok! use strict; use warnings; use Text::CSV; #use Encode; # probably not needed :encoding(utf8) #Input CSV filename my $file = $ARGV[0]; if (!$ARGV[0]) { $file = './data/IDs.csv'; #Default } if (!-f $file) { print "Kann Datei $file nicht finden: $!\n"; exit 1; } #Parsing CSV local $/ = "\r\n"; #add windows carriage return to perl's eol +(newline) my $csv = Text::CSV ->new ({binary =>1, eol => $/}); open (my $fhCSV, '<', $file) or die "Kann $file nicht öffnen $!\n"; open (my $fhOUT, '>', './data/IDs.txt') or die "Kann Datei nicht öffn +en: $!\n"; while (my $line = <$fhCSV>) { if ($csv->parse($line)) { my @fields = $csv->fields (); chomp (@fields); print $fhOUT "@fields\n"; } else { warn "Line could not be parsed: $line\n"; } } print "CSV parsed and saved as text file: /data/IDs.txt!"; close $fhCSV; close $fhOUT;

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (12)
As of 2018-05-23 13:24 GMT
Find Nodes?
    Voting Booth?