Shell Programming and Scripting

Hi.. I need to get the following output from the input file like this
INPUT

OUTPUT:

I need the best result row other than matching to itself.. like (GRM1 GRM1 0) as it is matching to itself i dont need it, i need next one only and ignore other rows in that set.. same as in second set, first row is not with itself so i can take it.. where as in third set, first three rows are matching to itself so i need fourth row..

I wrote a script in perl, its ignoring if it matches to itself but giving all other rows..

---------- Post updated at 11:04 PM ---------- Previous update was at 05:59 PM ----------

Any help please

I have a solution in awk:

Code:

awk 'V&&V!=$1{print vval;V=x} $1!=$2&&!V||$3<B{B=$3;V=$1; vval=$0} END{print vval}'

I am actually new to awk, I have two questions
Where can i provide input file name?
In the example i gave per set 4 rows are there but i have 5 rows per set in my original file, will it work for that also?

You can specify the filename at end of command line like this:

Code:

awk 'V&V!=.......' infile > outfile

Worked Great!!! Thank you so much

Chubler do you mind explaining the awk ?

Code:

awk 'V&&V!=$1{print vval;V=x} $1!=$2&&!V||$3<B{B=$3;V=$1; vval=$0} END{print vval}'

Code:

awk '$1!=$2&&++A[$1]==1' infile

---------- Post updated at 11:14 PM ---------- Previous update was at 11:13 PM ----------

Code:

$ cat tst
GRM1 GRM1 0
GRM1 ABC1 1
GRM1 FEQ1 2
GRM1 SED1 3
ABC2 GRM1 0
ABC2 ABC2 1
ABC2 FEQ1 2
ABC2 BED1 3
SED1 SED1 0
SED1 SED1 1
SED1 SED1 2
SED1 ABC1 3

Code:

$ awk '$1!=$2&&++c[$1]==1' tst
GRM1 ABC1 1
ABC2 GRM1 0
SED1 ABC1 3