Awk count frequencyHey i want to count the amount of data in a certain column in awk. an example dataset is 2 5 8 1 3 7 8 5 9 and I want to count the frequency of the 5 in the second colum. This is what i tried that didn't work { total = 0; for(i=1;i<=NF;i++) { if(i==2) {if($i==5) {total++;} } printf("%s ", total); } }
