use File::Copy;
use File::Find;


### Parse numerical characters and trailing white-space from rmtdb.lrl for matching.
copy("rmtdb.lrl" , "rmtdb.tmp")
   or die "rmtdb.lrl file cannot be copied: $!\n";
system "cat rmtdb.tmp | cut -d ' ' -f1 > rmtdb.tmp1";

### Open File Handles.
open comdb, "< dblist.comdbg"
   or die "Cannot open connection to dblist.comdb: $!\n";
open varldb, "< dblist.varldb"
   or die "Cannot open connection to dblist.varldb: $!\n";
open rmtdb, "< rmtdb.tmp1"
   or die "Cannot open connection to rmtdb.lrl: $!\n";

### Create Lists
@comdb = <comdb>;
@varldb = <varldb>;
@rmtdb = <rmtdb>;

### Close File Handles.
close comdb; close varldb; close rmtdb;

### Case-shift rmtdb to lowercase.
foreach (@rmtdb) {s/$_/\L$_/gi;}

### Begin matching.
foreach $db (@comdb)  # comdb against varldb.
{
   @result = grep /^\Q$db\E$/i , @varldb;
   push(@com2var , @result);
}

foreach $db (@comdb) # comdb against rmtdb.
{
   @result = grep /^\Q$db\E$/i , @rmtdb;
   push(@com2rmt , @result);
}

foreach $db (@varldb) # varldb against rmtdb.
{
   @result = grep /^\Q$db\E$/i , @rmtdb;
   push(@var2rmt , @result);
}

### Sort matches for final output.
foreach (@com2var)
{
   chomp($_);
   $hash1{$_}="dblist.comdbg dblist.varldb";
}

foreach (@com2rmt)
{
   chomp($_);
   if (exists $hash1{$_})
   {
   $hash1{$_}="dblist.comdbg dblist.varldb rmtdb.lrl";
   } else {
   $hash1{$_}="dblist.comdbg rmtdb.lrl";
   }
}

foreach (@var2rmt)
{
   chomp($_);
   if (! exists $hash1{$_})
   {
   $hash1{$_}="dblist.varldb rmtdb.lrl";
   }
}
  
### Final Output.
print "\n";
foreach (keys %hash1)
{
   print "$_ is duplicated in:  $hash1{$_}\n";
}
print "\n";

### Cleanup
unlink "rmtdb.tmp", "rmtdb.tmp1";

exit 0;