Shell Programming and Scripting

Please help me in fixing the following command:

awk -F "|" 'FNR==NR {a[$1]++; next} {print $0,a[$1]}' file1 file2 >>file3

File1
3308100100|C|20.83|21.87|22.91|04/APR/2009|2009|02|MAR
0102110500|C|5.01|5.26|5.51|04/APR/2009|2009|02|MAR
3308100100|C|18.74|19.67|20.61|04/APR/2009|2009|02|MAR
0102140200|C|5.07|5.32|5.57|04/APR/2009|2009|02|MAR
3308100100|C|741.50|778.58|815.65|04/APR/2009|2009|02|MAR
0104100400|C|41.26|43.33|45.39|04/APR/2009|2009|02|MAR
0530100300|C|38.26|40.17|42.08|04/APR/2009|2009|02|MAR

file2
3308100100|Store Inventory Turns Without Gas(FT LEONARD WOOD MS)
0530100300|Total Markdowns(FT BRAGG MS - SOUTH)
4792999900|Productivity(TRAV AFB)

the file3 should be like this:
3308100100|C|20.83|21.87|22.91|04/APR/2009|2009|02|MAR|Store Inventory Turns Without Gas(FT LEONARD WOOD MS)
3308100100|C|18.74|19.67|20.61|04/APR/2009|2009|02|MAR|Store Inventory Turns Without Gas(FT LEONARD WOOD MS)
3308100100|C|741.50|778.58|815.65|04/APR/2009|2009|02|MAR|Store Inventory Turns Without Gas(FT LEONARD WOOD MS)
0530100300|C|38.26|40.17|42.08|04/APR/2009|2009|02|MAR|Total Markdowns(FT BRAGG MS - SOUTH)


you can see comparision is being done on column 1 of both the files...if column1 of file 1 matches with column 1 of file2 then we need to append column 2 of file 2 in the end of matching rows from file1............please let me know if it is possible or not?

Next time, please start a new thread for a NEW issue.

Code:

awk -F '|'  'FNR==NR {a[$1]=$2; next} $1 in a {print $0,a[$1]}' OFS='|' file2 file1

perl

Code:

while(<DATA>)
{
	my @tmp=split("[|]",$_);
	$hash{$tmp[10]}=1;
}
open $fh,"<","a.txt";
while(<$fh>){
	my @tmp=split;
	my @t1=split("[.]",$tmp[0]);
	print if exists $hash{$t1[1]};
}
__DATA__
9000|9000|WW|1|1|SL|472|472|LC|2272|1072|MTY
9000|9000|WW|1|1|SL|470|470|MC|1270|1172|MPVT
9000|9000|WW|1|1|SL|472|472|LC|1072|1672|MBD
9000|9000|WW|1|1|SL|473|473|LF|1173|1173|MTY

Thanks vgersh99....I will start next thread as you suggested but one more help as it is related to this one only......if it had been a column 4 (instead of column 1)of file 1 and column 5 (instead of column 1)of file2 then how would we have written this command.

Code:

awk -F '|'  'FNR==NR {a[$5]=$2; next} $4 in a {print $0,a[$4]}' OFS='|' file2 file1

THANKS MUCH for your kind help.