Bash – grep for repeated values from pattern list

awkbashgrep

I have file A.txt which is a lists of unique ids (column 1) and its corresponding values(column 2):

A.txt

ABC1D_T1_B1  123.4
ABC2D_T1_B2  146.7
ABC3D_T1_B1  567.8
ABC4D_T0_B2  96.8
ABC1D_T0_B1  145.9

Second file is B.txt, not unique but has duplicated entries

ABC1D_T1_B1
ABC1D_T1_B1
ABC2D_T1_B2
ABC3D_T1_B1
ABC3D_T1_B1
ABC4D_T0_B2
ABC1D_T0_B1
ABC1D_T0_B1

How can I grep B.txt from A.txt and report the values of col 2 for the repeated list

Result:

ABC1D_T1_B1  123.4
ABC1D_T1_B1  123.4
ABC2D_T1_B2  146.7
ABC3D_T1_B1  567.8
ABC3D_T1_B1  567.8
ABC4D_T0_B2  96.8
ABC1D_T0_B1  145.9
ABC1D_T0_B1  145.9
ABC1D_T0_B1  145.9

Normally if unique entries are there in B.txt then

grep -Fw -f B.txt A.txt >Result.txt

How can I do this for multiple repeating entries using grep?

Best Answer

Since you have also tagged awk:

awk 'FNR == NR {a[$1] = $0; next}; {print a[$1]}' A.txt B.txt

I don't think a single grep can do this, but a combination of xargs and grep:

xargs -I{} grep -Fw -- {} A.txt < B.txt

Related Solutions

Bash – Identifying duplicate fields and print both with awk

uniq is the correct tool for that:

uniq -D -f2 file

Where:

-D - prints all duplicates
-f2 - avoid comparing the first 2 fields

Edit: If the fields 7 and above are not to be compared, you need awk:

awk 'n=x[$3,$4,$5,$6]{print n"\n"$0;} {x[$3,$4,$5,$6]=$0;}' file

The array item x[] (columns 3-6) is checked. If it's already set run the part in {...} (in the same statement the n variable is set to the value of that array item)
In the brackets {...}: The n variable and the current line $0 are printed.
Then we set the x[] array item for the next iteration to the current line contents, for later comparsion.

Bash – Keeping First Instance of Duplicates

sort itself should suffice. First sort such that rows are "grouped" by field range 3-6, records within each group further ordered by fields 5 and 1. Pipe this to sort -u on 3-6, this disables last-resort comparison and returns the first record from each 3-6 group. Finally, pipe this to sort, this time by fields 5 and 1

sort -k3,6 -k5,5r -k1,1r file | sort -k3,6 -u | sort -k5,5r -k1,1r
A B C D E F G
1 2 T TACA A 3 2 Q
9 3 A C 9 3 P
8 3 I R 8 2 Q

Best Answer

Related Solutions

Bash – Identifying duplicate fields and print both with awk

Bash – Keeping First Instance of Duplicates

Related Question