I tried as suggested but cant get your new script to work on my text file. Please advise what Iam doing wrong.
Thanks.
my $db = 'C:\Inetpub\wwwroot\cgi-bin\test4.txt';
open(DATA, "$db") || die "Can not open: $!\n";
my @dat = (<DATA>);
close(DATA);
open(DATA, "$db") || die "NO GO: $!\n";
my %seen;
while (<DATA>){
my ($value,$key) = $_ =~ /^([^\|]+)\|(.*)/;
my ($key,$value) = split(/\|/,$_,2);
next if $seen{$value};
print "$key: $value\n";
push(@files,$key);
my @files = (<DATA>);
print DATA @files;
$seen{$value}++;
}
close(DATA);