mjhjmtu

I would like to extract records of a file based on a condition. The file contains 47 fields, and I would like to extract only those records that match a certain value in one of the columns, e.g.

1 XX 45 N
2 YY 34 y
3 ZZ 44 N
4 XX 89 Y
5 XX 45 N
6 YY 84 D
7 ZZ 22 S
8 ZX 12 6
9 ZA 32 8

From this file, I would like to extract all records whose COL2=XX and YY, ZZ and all other records will be excluded (as shown below).

1 XX 45 N
2 YY 34 y
4 XX 89 Y
5 XX 45 N
6 YY 84 D

Does anybody know how to do this using sed or awk or any other UNIX tool? Thank you.

Let's say your data is listed in a file called file.txt.You can try awk as follows:

awk '$2 ~ /XX|YY|ZZ/' file.txt
1 XX 45 N
2 YY 34 y
3 ZZ 44 N
4 XX 89 Y
5 XX 45 N
6 YY 84 D
7 ZZ 22 S

or grep

grep 'XX|YY|ZZ' file.txt
1 XX 45 N
2 YY 34 y
3 ZZ 44 N
4 XX 89 Y
5 XX 45 N
6 YY 84 D
7 ZZ 22 S

To sort the data based on the third column, you can pipe the output data to the command sort as follows:

grep 'XX|YY|ZZ' file.txt | sort -k3,3n
7 ZZ 22 S
2 YY 34 y
3 ZZ 44 N
1 XX 45 N
5 XX 45 N
6 YY 84 D
4 XX 89 Y