title: Replace a specific column of a specific row with awk
body: <p>i am using the following code to replace column 8 of row 10 with the sum of column 8 divided by 10, which should give me an average of that column. I then want to print the final row. It hasnt worked so far. </p>
  
  <pre><code>awk -F "|"  '{sum+= $8} FNR==10{$8=$sum/10}'
  </code></pre>
  
  <p>I would appreciate any help, thank you</p>