#!/usr/bin/perl use warnings; use strict; $[ = 1; $\ = "\n"; my ($last_xdrfile,$xline); open CDR_DETAILS, "cdr_details.1" or die "couldn't open cdr_details.1: $!\n"; open CDR_TDM, ">cdr_tdm.csv" or die "couldn't write cdr_tdm.csv: $!\n"; while () { chomp; my ($cdrdate,$cdrtime,$cdrcli1,$cdrcli2,$xdrfile) = (split /,/)[1,2,3,7,8]; $cdrtime += 0; print "Record number: $."; print "CDRDATE: $cdrdate"; print "CDRTIME: $cdrtime"; print "CLI1: $cdrcli1"; print "CLI2: $cdrcli2"; if ($last_xdrfile ne $xdrfile) { print "$xdrfile != $last_xdrfile, opening file!"; open(XDR,$xdrfile) or die "couldn't open $xdrfile: $!\n"; chomp($xline = ); } $last_xdrfile = $xdrfile; while (defined $xline) { my ($xdrdate,$xdrtime,$xdrcli1,$xdrcli2)=(split /,/, $xline)[2,3,5,7]; last if $xdrdate gt $cdrdate; last if $xdrtime gt $cdrtime; next unless $xdrdate eq $cdrdate && $xdrtime eq $cdrtime && $xdrcli1 eq $cdrcli1 && $xdrcli1 eq $cdrcli2; print CDR_TDM $xline; } continue { chomp($xline = ) } }