Columns Manipulation using AWK

[folashandy]

I'm not familiar with 'awk' but ran into column manipulation problem in Linux. The problem is, l have 2 different files for simplicity sake file1 & file 2. Both files have 50 columns, what l want to do is to copy the values of columns 43 to 50 from file1 into columns 43 to 50 in file 2. Also, l want to output the result into a new file. Can anybody help me out with the way to go about this? The number of records in the file is about 5000 records.

The records are in this format:
123,234,456,..............


Shand

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[wardy66]

do you want to overwrite cols 43 to 50 in file2? And leave col 1-42 alone?

Does its format look the same as the example you gave?