replace a field in a CSV file

prvnrk · #1 (**permalink**) 11-12-2008

Hello all,

I've a CSV file and need to replace 5th field if its value is "X".

The exact requirement is to replace 5th field (column) with "Y" if
a. it's value is "X" AND
b. the line must start with ABC string

i guess this can be done with awk. Pl help.

For security reasons, the actual file format and contents are changed.

Thanks
Prvn

danmero · #2 (**permalink**) 11-12-2008

Code:

awk '$1 ~ /^ABC/ && $5=="X"{$5="Y"}1' file

prvnrk · #3 (**permalink**) 11-12-2008

Thank you danmero,

It worked great.

I just had to add -vOFS="," to get the output with commas.

Thanks!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
replace single field out of 60	ajp7701	Shell Programming and Scripting	2	04-21-2008 08:17 PM
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 08:56 AM
replace a similar field in a file	chiru_h	Shell Programming and Scripting	2	11-01-2006 05:23 PM
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