Shell Programming and Scripting

Hello Group,

I request you your help in order create a script for joint two files in one. The idea is to create a new row where the date is the same in both files.

file 1
1/1/2010, 2
1/2/2010, 4
1/3/2010, 6
1/4/2010, 8
1/5/2010, 10

file 2
1/1/2010, 3
1/2/2010, 6
1/3/2010, 9
1/4/2010, 12
1/6/2010, 15

Result file
1/1/2010, 2, 3
1/2/2010, 4, 6
1/3/2010, 6, 9
1/4/2010, 8, 12

I really appreciate it your help

Carlos

Code:

perl -e 'my %hash;
open my $fh1 , "<", "file1" || die "$!";
while (<$fh1>) {
 chomp;
my ($date,$val) = split(",");
$hash{$date} = $val; }
close $fh1;

open my $fh2 , "<" ,"file2" || die "$!";
while (<$fh2>){
chomp;
 my ($date,$val) = split(",");
print "$date,$hash{$date},$val\n" if (exists $hash{$date});
}
close $fh2;  > result_file

HTH,
PL

Try this one:

Code:

awk -F", " 'NR==FNR{a[$1]=$2;next}{$0=a[$1]?$0 FS a[$1]:$0}1' file2 file1

---------- Post updated at 10:54 PM ---------- Previous update was at 10:53 PM ----------

and please use [code] tags when you post data sample or code.

Or this:

Code:

join -t, file1 file2