Replace 10th column with a new column--- Terriblly hurry

ahmedwaseem2000 · #1 (**permalink**) 09-06-2005

Hi Can any one tell me how to replace the 10th column in a file(comma delimted) with a new file with a single column. Can any one Help me out of the please as soon as possible as i am in a terribley hurry!!!!!!

Many THanks,

RishiPahuja · #2 (**permalink**) 09-06-2005

Suppose your existing file has n columns then using "paste" command make it n+1. this is the new column you want in file.
Next with help of awk reformat the columns as you desire.

something:

Code:

paste file1 file2 > file3   //pls see the manual of paste i m not too sure of the syntax.
awk -F"," 'print $1","$2....$n+1...$n' etc

ahmedwaseem2000 · #3 (**permalink**) 09-06-2005

Thanks a ton Rishi for your quick swift solution- Cheero !!!!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Replace string in column	mohan705	UNIX for Advanced & Expert Users	3	03-13-2009 12:52 PM
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
replace a column values with the first value in column	sumeet	UNIX for Advanced & Expert Users	3	02-06-2007 01:13 PM

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


	Powered by