Shell Programming and Scripting

Hi,

Here is my sample input

In field 1, if the value of one line is same as that of next line, I want to concatenate the corresponding value of the second line in the third field with the value of the third field of first line. And I dont need the third line in the out put. phew!

Needed Output

I am a biologist and have no Idea regarding awk scripting. So please dont ask me what I have tried

Thank you very much in advance.

Try:

Code:

perl -p0e 's/^(\w)(.*)(\w+)\n\1.*?(\w+)$/\1\2\3_\4/mg' file

Code:

awk 'END {
  for (i = 0; ++i <= c;)
    print d[idx[i]]
  }
{
  d[$1] = d[$1] ? d[$1] OFS $3 : $0
  t[$1]++ || idx[++c] = $1
  }' OFS=_ infile