Hi guys,
Please help me if u have some solution.
I have a file with three columns separated by ':' -
INPUT_FILE
C416722_2 : calin Dirigent : Dirigent
AC4174_6 : Jac : cal_co
TC4260_5 : [no : lin kite
BC426302_1 : [no : calin Dirigent lin
JC426540_3 : lin Pymo_bin : calin
TC428_3 : no7 cal_co : no7 cal_co
I need the output such that It contain four columns and column4 should contain combined words of column2 and column3 but uniq.
OUTPUT_FILE
C416722_2 : calin Dirigent : Dirigent : calin Dirigent
AC4174_6 : Jac : cal_co : Jac cal_co
TC4260_5 : [no : lin kite : [no lin kite
BC426302_1 : lin : calin Dirigent lin : calin Dirigent lin
JC426540_3 : lin Pymo_bin : calin : lin Pymo_bin calin
TC428_3 : no7 cal_co : no7 cal_co : no7 cal_co
Thanks in advance