UNIX for Dummies Questions & Answers

Hello,

I am having issues generating the output file below from this input file:
Basically, what I want is if the ID= matches with the line below to print the first value in column 3 and the last value of column 4 for the matching ID's. The ID's can repeat more than twice, however, they will always be in order and not scattered throughout the file.

This is the output I want:



I have generated the code below so far but it has proven unsuccessful since it sums up the values column 3 and 4 and does not print simply the first match of column 3 and last of match of column 4 for matching ID's

Code:

 awk '$3=="exon" && $9~/^ID/{sub(/_T.*/,"",$9);L[substr($9,4)]print $5-$4+1}END{for(i in L){print i,L[i]}}' filename > out

any ideas?

someting like this ?

Code:

awk '$2!=x;{x=$2}' FS="=" infile

Unfortunately that did not work. It went from

to

but it needs to print the first number of the first match of column 3 and the second matches column 4

---------- Post updated at 02:21 PM ---------- Previous update was at 02:11 PM ----------

So the idea is to basically group every line based on the ID= and print the first number in col3 (which should be the smallest ) and the last number of col4 (which should be the largest).