Data matching 1

[alan147]

Good afternoon

I urgently need to select data from one file where the entry in field 1 matches the data in field 1 of a second file does anyone have a solution?

Thanks

Alan

 

[PHV]

A starting point:

awk 'NR==FNR{t[$1];next}($1 in t)' "second file" "one file" > output

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[alan147]

Great, you've really helped me out.

Thanks very much.

Alan