Shell Programming and Scripting

Code:

awk '
  BEGIN {                                        
     FS = OFS = ";"   
  }

  FNR==NR { arr[$4]=$0; next }
  $1 in arr { print arr[$1] }
  ' gmrd.txt core_extract.txt

using the code above on the following two files:

core.txt:

5069211;00;123
NOASCOMGR;03;143
US36204YA782;00;156
XS0147500028;00;132

gmrd.txt

BAY GR;03;1344;432
235649;03;2563;598
291802;00;2563;598
979217;00;2563;598
235649;03;2563;598
A0ABVB;00;2563;598
235649;03;2563;598

and the following code:

awk '
BEGIN {
FS = OFS = ";"
}

FNR==NR { arr[$2]=$0; next }
$2 in arr { print arr[$1] }
' gmrd.txt core.txt

this results in null output - even though the first file contains a '03'

is this right?

Code:

 $2 in arr { print arr[$2] }

can i award vg a medal for being brainy!

thanks for all your help

after having tried this and based on the above two text files the output that is produced is:

A0ABVB;00;2563;598
235649;03;2563;598
A0ABVB;00;2563;598
A0ABVB;00;2563;598

- what am i doing wrong? As what is should produce is the records in gmrd.txt that have the same second field as in core.txt

seems like the SECOND field in BOTH files is NOT UNIQUE.

what gets printed out is the LAST row from gmrd for a given SECOND field.

seems like having ONLY the second field is NOT enough to identify records UNIQUELY. You might consider either using a DIFFERENT field and/or using a combination of fields from both files to do your "lookup".

is there anyway to overcome this as the only field common to both is the second field. would I have to create a variable out of the second fields in core.txt and then from that check gmrd.txt