I am trying to access a variable defined in awk multiple times, but it does not seem to work.
Lets assume we have a data.txt with contents:
1 2
2 3
3 4
If we do awk with:
cat data.txt | awk 'sum=($1+$2), div1=(sum/$1) {print " sum: " sum " div1: " div1 " data: " $0}'
It works fine and we get an output of
sum: 3 div1: 3 data: 1 2
sum: 5 div1: 2.5 data: 2 3
sum: 7 div1: 2.33333 data: 3 4
If I try to access the sum multiple times, I get an error
cat data.txt | awk 'sum=($1+$2), div1=(sum/$1), div2=(sum/$2) {print " sum: " sum " div1: " div1 " div2: " div2 " data: " $0}'
Even if I change div2=(sum/$2) to div1=(sum/$1), which is exactly the same as before, I will still get the error:
awk: line 1: syntax error at or near ,
How can I get around this issue and access any specific variable assigned in awk to be accessible multiple times?
>Solution :
The part before the {} block is supposed to be a condition. Put variable assignments inside the {}. Multiple statements are separated using ;.
cat data.txt | awk '{sum=($1+$2); div1=(sum/$1); div2=(sum/$2); print " sum: " sum " div1: " div1 " div2: " div2 " data: " $0}'