Need urgent Help, How to modify file using awk or sed??

[Vivek_3]

Hi to all,

I need to relese a script by today itself. please help me to do this.

I have a big file lets say 65 thousand lines. it is a tab seperated text file. i need to add one more columne at the end of every line ( tab seperated). the value of that column is the first column of the first line.

example:

Inputfile:

NY^hhhhh^hhhhh^kkkkk^gggg
hhh^jjjjj^9999^44444
888^hhhh^443444^hhhhhh

Output file

NY^hhhhh^hhhhh^kkkkk^gggg^NY
hhh^jjjjj^9999^44444^NY
888^hhhh^443444^hhhhhh^NY

here '^' represent tab character.


please help me ASAP.

vivek S.
viveks@fox.com

[Mark Fenton · Accepted solution]

Well a little snippet of code:

export FIELD=`head -1 filename| awk ' { print $1 } '
awk -v FIELD=$FIELD '{ FS = "\t" } { print $0, FIELD } ' filename.new

should handle the job for you.

hth
mark

[Vivek_3]

Thanks Mark.