replace a column values with the first value in column

sumeet · #1 (**permalink**) 02-06-2007

Hi All,

I have a file which has data in following format:

"Body_Model","2/1/2007","2/1/2007"
"CSCH74","0","61"
"CSCS74","0","647"
"CSCX74","0","3"
"CSYH74","0","299"
"CSYS74","0","2514"
"CSYX74","0","3"
"Body_Model","3/1/2007","3/1/2007"
"CSCH74","0","88"
"CSCS74","0","489"
"CSCX74","0","4"
"CSYH74","0","386"
"CSYS74","0","1871"
"CSYX74","0","4"

I want to have to convert to get following :

"Body_Model","2/1/2007","2/1/2007"
"CSCH74","2/1/2007","61"
"CSCS74","2/1/2007","647"
"CSCX74","2/1/2007","3"
"CSYH74","2/1/2007","299"
"CSYS74","2/1/2007","2514"
"CSYX74","2/1/2007","3"
"Body_Model","3/1/2007","3/1/2007"
"CSCH74","3/1/2007","88"
"CSCS74","3/1/2007","489"
"CSCX74","3/1/2007","4"
"CSYH74","3/1/2007","386"
"CSYS74","3/1/2007","1871"
"CSYX74","3/1/2007","4"

Can any of Unix Gurus help me.

Thanks
Sumeet

Glenn Arndt · #2 (**permalink**) 02-06-2007

Code:

awk 'BEGIN { FS="," }
 $1 ~ /Body_Model/ { mydate=$2; print; next }
 { print $1, mydate, $3 }' file.txt

vgersh99 · #3 (**permalink**) 02-06-2007

Quote:

Originally Posted by Glenn Arndt

Code:

awk 'BEGIN { FS="," }
 $1 ~ /Body_Model/ { mydate=$2; print; next }
 { print $1, mydate, $3 }' file.txt

Glenn,
you forgot to assign the OFS.

Code:

nawk 'BEGIN { FS=OFS="," }
 $1 ~ /Body_Model/ { mydate=$2; print; next }
 { print $1, mydate, $3 }' file.txt

Glenn Arndt · #4 (**permalink**) 02-06-2007

Oops! Thanks for catching that.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
replace the column values.	charandevu	Shell Programming and Scripting	6	04-02-2008 02:21 AM
how to read the column and print the values under that column	gemini106	Shell Programming and Scripting	6	03-28-2008 07:05 AM
How to check Null values in a file column by column if columns are Not NULLs	Mandab	Shell Programming and Scripting	7	03-15-2008 09:57 AM
Capturing the values of column in one parameter	mgirinath	Shell Programming and Scripting	5	06-14-2006 01:43 PM
Replace 10th column with a new column--- Terriblly hurry	ahmedwaseem2000	Shell Programming and Scripting	2	09-06-2005 01:10 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