Re: Opening multiple files

[Anonymous Monk]

Um, paste -d, one two three four > onetofour.csv

$ perl -e " for my $l ( a..c ){ open $fh, '>', $l; print $fh qq[$l$_\n
+] for 1 .. 3; } "

$ paste -d, a b c
a1,b1,c1
a2,b2,c2
a3,b3,c3

[Anonymous Monk]

#!/usr/bin/perl --
use strict; use warnings;
use Text::CSV;
use autodie qw/ open close /;
Main( @ARGV );
exit( 0 );
sub Main {
    return Usage() unless @_ > 2;
    
    my( $outfile, @infiles ) = @_;
    my $csv_out = Text::CSV->new( {
        always_quote => 1,
        binary       => 1,
        eol          => $/,
    } ) or die Text::CSV->error_diag();
    
    open $outfile, '>:raw', $outfile; # autodie
    
    $csv_out->print( $outfile, \@infiles ) or die $csv_out->error_diag
+ ;
    
    @infiles = map { open my $fh, '<:raw', $_; $fh  } @infiles;
    
    while( not( grep eof, @infiles ) ){
        my @lines = map { scalar readline( $_ ) } @infiles;
#~         chomp( @lines );
#~         no warnings 'uninitialized';
#~         s/[\r\n]+$// for @lines;
        s/[\r\n]+$// for grep defined, @lines;
        $csv_out->print( $outfile, \@lines ) or die $csv_out->error_di
+ag ;
    }
    
    undef $csv_out;
    close $outfile; # autodie
} ## end sub Main


sub Usage {
    print <<"__USAGE__";

$0    
$0    outFile.csv   inOne.csv inTwo.csv inThree.csv ...


EXAMPLE SESSION

    \$ perl csv.paste.pl    out.csv  ta.csv  tb.csv  tc.csv  td.csv

    \$ cat out.csv
    "ta.csv","tb.csv","tc.csv","td.csv"
    "a1","b1","c1","d1""st(i)n,ker"""
    "a2","b2","c2","d2'st(i)n,ker'"
    "a3","b3","c3","d3""'st(i)n,ker'"""
    ,,,"d4 stinker unquoted "

__USAGE__
} ## end sub Usage

[Anonymous Monk]

Correction

-  while( not( grep eof, @infiles ) ){

+  while( not( grep \&eof, @infiles ) ){

[Anonymous Monk]

Probably want  while( not grep { eof $_ } @infiles ){

[mcasspj]

Cheers, the reasons I didn't want to use paste are:
1. The people who may use this wont be on linux/unix boxes or have cygwin.
2. I want to include some pre-processing in the program, it's Russian Election Data scraped from the web and needs a little cleaning i.e. numbers are formatted with spaces.
3. To learn some Perl.
Many Thanks
Paul