Shell Programming and Scripting

Hi Guru,
I need some help regarding awking the output so it only show the first line (based on column) of each row.

So If column has 1, three row, then it only show the first line of that row, based on similar character in column 1. So i am trying to achieve a sort, based on column one and only show the first line.

I used the follownig command - awk NF==1'{print $2,$9}', but naturally this is giving the wrong output.

See below.


Output

Code:

1 CAG760
1 CAG123
1 CAI000
2 CBH628
2 CBI123
2 CBH630

Output Required

Code:

1 CAG760
2 CBH628

Code:

$ awk '{ if (L!=$1) print; L=$1}' inputfile
1 CAG760
2 CBH628

Worked a treat thanks.

Another approach:

Code:

awk '!A[$1]++' file