nixCraft

Hi,

I tried to subtract a specific number which I have already read from another file to whole numbers of a column each time and then I want to have my whole file by these changes. I used below command but it did not work properly.
I wonder how I could solve the problem??
I want that each time it could read a number from medium_magnitude_test.param file and then subtract the number from the given column and then it saves the results.

for FILTER in MB416 MB461 MB485 MB518 MB571 MB604 MB646 MB696 MB753 MB815 MB856 MB914
do
for i in $(seq 6 17);
do
k=`grep "MAGZP_${FILTER}" ${MainD}/medium_magnitude_test.param | awk '{print $3}'`
echo ${k}
awk 'BEGIN { $i=$i-k print $0 }' ${MD}/seventeen_filters_10.asc > test00.asc
done
done

I have no idea what you are trying to do, but calling three external programs in a nested loop is almost certainly the wrong way to go about it.

No only that, but you are trying to use shell variables inside an awk script.

The variables will not be expanded inside single quotes.

awk does not process data in the BEGIN block, hence, printing wouldn't work there. This is where you handle operation before awk start processing the data in the main section.

Try changing the following:
awk 'BEGIN { $i=$i-k print $0 }' ${MD}/seventeen_filters_10.asc > test00.asc

to:
awk -v d=$k -v c=$i 'BEGIN { deduct=d; column=c; } { $column = $column - deduct; print $0 }' ${MD}/seventeen_filters_10.asc > test00.asc

See if this works.


Thanks,
- NNS