UNIX for Dummies Questions & Answers

Hi all,

I have a problem that I'm struggling to resolve. I have two files that look like this:

Code:

File 1
654654654 3
987987987 2
321321321 1

Code:

File 2
14NS0064 654654654
14NS0054 654654654
14NS0032 654654654
14NS0090 987987987
14NS0093 987987987
14NS0056 321321321

As you may notice, file 1 counts the occurrences of each value in column 2 in file 2. Generating file 2 from file 1 was no issue but what I would like to do now is append to new columns in file 1 the values in column 1 in file 2 that have the same value in column 2. So, my desired output is:

Code:

654654654 3 14NS0064 14NS0054 14NS0032
987987987 2 14NS0090 14NS0093
321321321 1 14NS0056

Thanks in advance for any help.

Try

Code:

awk '{A[$2]=A[$2] " " $1; B[$2]++} END {for (i in A) print i, B[i], A[i]}  ' file2
987987987 2  14NS0090 14NS0093
321321321 1  14NS0056
654654654 3  14NS0064 14NS0054 14NS0032

Thank you very much, it works perfectly.