title: awk count number of fields and add accordingly
body: <p>I have the following file.csv </p>
  
  <pre><code>111111 | 111111 | 22222 | 44444 | 4445454 | 67554333 | 
  </code></pre>
  
  <p>I can count the number of fields using the following </p>
  
  <pre><code>awk -F '|' '{print NF}' file.csv
  </code></pre>
  
  <p>in my database schema I have 33 fields, however some of the lines in my csv file has less than 33 fields therefore when I import the file, it complains about miss match.  </p>
  
  <p>using awk how can I go about adding NULL fields spreader by | in order to full up 33 rows </p>
  
  <p>your help is highly appreciated. </p>
  
  <p>Thank you</p>