title: Delete rows of CSV file based on the value of a column
body: <p>Here's an example of a few lines of my CSV file:</p>
  
  <pre><code>movieID,actorID,actorName,ranking
  1,don_rickles,Don Rickles,3
  1,jack_angel,Jack Angel,6
  1,jim_varney,Jim Varney,4
  1,tim_allen,Tim Allen,2
  1,tom_hanks,Tom Hanks,1
  1,wallace_shawn,Wallace Shawn,5
  </code></pre>
  
  <p>I would like to remove all rows that have a ranking of > 4, so far I've been trying use this awk line:</p>
  
  <pre><code>awk -F ','  'BEGIN {OFS=","} { if (($4) &lt; 5)  print }' file.csv &gt; file_out.csv
  </code></pre>
  
  <p>It should print all the rows with a ranking (4th column) of less than 5 to a new file. I can't tell exactly what this line actually does, but it's not what I want. can someone tell me where I've gone wrong with that line? </p>