Shell Programming and Scripting

Hi,

I want to replace a column in a file with a file that only has one column. Reading another post this is what I'm trying to do,

The existing file has n columns and I paste the extra column using the paste command to make it n+1

Code:

paste file1 file2 > file3

Firstly I want to now remove say column 7 from file3 and then re-arrange the columns so that the n+1 column becomes the 7th column. How would I do this using awk?

Thanks.

Post a sample date(from your files) and will try to find a solution.

If File1 is the file with one column, this should replace the 7th column of File2 with the column of File1.

Code:

awk 'NR==FNR{a[NR]=$0; next} {$7=a[FNR]}1' File1 File2

Thanks! Works like a charm.