Shell Programming and Scripting

Well, I guess we didn't understand each other for now. I thought you wanted to get all the entries from both files sorted based on XXXXXX_RANDOM string. If that is not the case, then please be precise on what you want to get, providing sample data consisting of few records from both files and desired output for that sample.

that's because we come from different disciplines!

I have a short example with a readme file attached to this post as you have suggested... Hope it helps more, and we can understand each other!

Try this script:

Code:

#!/usr/bin/perl
open A,"$ARGV[0]";
open B,"$ARGV[1]";
local $/;
$_=<A>;
while (/^[^_]+_(\w+)([^\t]+\t){5}([^\t]+).*?=+\n/msg){
  $h{"$1$3"}=$& if ! $h{"$1$3"};
}
$_=<B>;
while (/^[^_]+_(\w+)([^\t]+\t){5}([^\t]+).*?=+\n/msg){
  print $h{"$1$3"} . $& if grep /$1$3/,keys %h;
}

Run it as: ./script.pl file1.txt file2.txt > output

this is magic! Thanks, bartus! This is exactly what I wanted!
if you have time, can you please explain me the script?
thanks again man!