Filter record from a file

Shell Programming and Scripting
1

Reposting since I didnt not get any reply.

I have a problem while filtering records from a file. Can somebody help please?

For eg: Consider the below files
Record file:

0003@00000000000190@20100401@201004012010040120100401@003@
0003@00000000000200@20100329@201003292010032920100329@003@
0003@00000000000550@20100401@201004012010040120100401@048@
0003@00000000000910@20100401@201004012010040120100401@017@
0004@00000000001401@20100328@201003282010032820100328@300@
0004@00000000001401@20100401@201004012010040120100401@010@
0004@00000000001431@20100401@201004012010040120100401@010@
0005@00000000001441@20100329@201003302010033020100330@300@
0005@00000000001830@20100328@201004012010040120100401@300@
0005@00000000002080@20100329@201003292010032920100329@003@

Filter File:

0004@300@20100328@20100329
0005@300@20100328@20100329

awk -F\@ 'NR==FNR{f[$1,$3,$5];next}($1SUBSEP$3SUBSEP$2 in f) {print $0}' $Record $Filter

This will not work since we are comparing 1st position to 1st, 3rd to 3rd and 5th to 2nd.

But if the filter file was like below this code would have worked.

 awk -F\@ 'NR==FNR{f[$1,$3,$5];next}($1SUBSEP$3SUBSEP$5 in f) {print $0}' $Record $Filter 

0004@300@20100328@20100329@300
0005@300@20100328@20100329@300

Could somebody help me to figure out how we can make the first process work?

2

How about:

awk -F\@ 'NR==FNR{f[$1,$2,$3];next} $1SUBSEP$5SUBSEP$3 in f' $Filter $Record 

0004@00000000001401@20100328@201003282010032820100328@300@
0005@00000000001830@20100328@201004012010040120100401@300@