• Author: Abdullah Azzam
• Data: column_appending_problem.zip

How do you append a new column to an object file from a source file? The object file is for a certain coordinate and contains the timeseries of multiple climatic parameters. The source file vs.txt has wind speed values for all the coordinates in a sequence, which means starting from the n row, the wind speed value for the next day is after 36,217 rows. 36,217 is the total number of coordinates which means that the wind speed needs to be appended in 36,217 files. The object files have naming pattern of $lat_$lon_lwave.mtc43.

doit.sh

#!/bin/sh
for i in *.mtc43; do
        coor=$(echo $i | sed 's/_/,/; s/_.*//')
        (
                echo -e "\n\nWind\n(m/s)"
                grep $coor vs.txt | cut -d, -f3
        ) > tmp.$$
        paste $i tmp.$$ > tmp2.$$
        mv tmp2.$$ $i
done
 
rm -f tmp*.$$