replace single field out of 60

ajp7701 · #1 (**permalink**) 04-21-2008

I have a pipe delimited file with over 60 fields on each line, and hundreds of lines...I want to replace field 6 only....

So what is the better way to do this command....

awk -F'|' '{print $1"|"$2"|"$3"|"$4"|"$5"| TXT6"$7"|"$8"|"....$59"|"$60}' infile > outfile

I dont even know if this would work but its the first thing off the top of my head that could work...

vgersh99 · #2 (**permalink**) 04-21-2008

Code:

nawk -F'|' -v OFS='|' '$6="TXT6" $7' infile > outfile

ajp7701 · #3 (**permalink**) 04-21-2008

thank you thank you thank you vgersh99 that works perfect!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Replace field in csv	pcboss	Linux	4	01-19-2008 06:24 PM
how to replace field for each record	happyv	Shell Programming and Scripting	12	06-26-2007 07:56 AM
Replace password field using ed/sed	munch	UNIX for Dummies Questions & Answers	6	04-30-2007 11:01 PM
find pattern and replace another field	sergiioo	Shell Programming and Scripting	3	04-11-2007 12:19 AM
Replace 10th Field by 2	PradeepRed	Shell Programming and Scripting	2	01-19-2006 03:46 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by