topic Need urgent Help, How to modify file using awk or sed?? in Operating System - Linux

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

Vivek_3 — Fri, 11 Jan 2002 18:01:05 GMT

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

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

Mark Fenton — Fri, 11 Jan 2002 23:21:21 GMT

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

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

Vivek_3 — Fri, 11 Jan 2002 23:32:11 GMT

Thanks Mark.