title: How to delete duplicated rows on one file based on a common field between two files with AWK?
body: <p>I have two files </p>
  
  <ol>
  <li><p>File 1 contains 3 fields     </p></li>
  <li><p>File 2 contains 4 fields </p></li>
  </ol>
  
  <p>The number of rows of File 1 is much smaller than that of File 2</p>
  
  <p>I would like to compare between two files based on 1st field with the following operation </p>
  
  <p><em>If the first field in any row of file 1 appears in the first field of a row in file 2, don't print that row for file 2.</em></p>
  
  <p>Any advice would be grateful. </p>
  
  <pre><code>Input File 1
  
   S13109 3739 31082 
   S45002 3800 31873 
   S43722 3313 26638 
  
  Input File 2
  
   S13109 3738 31081 0 
   S13109 3737 31080 0 
   S00033 3008 29985 0 
   S00033 3007 29984 0 
   S00022 4130 31838 0 
   S00022 4129 31837 0 
   S00188 3317 27372 0 
   S45002 3759 31832 0 
   S45002 3758 31831 0 
   S45002 3757 31830 0 
   S43722 3020 26345 0 
   S43722 3019 26344 0 
   S00371 3737 33636 0 
   S00371 3736 33635 0 
  
  Desired Output
  
   S00033 3008 29985 0 
   S00033 3007 29984 0
   S00022 4130 31838 0 
   S00022 4129 31837 0 
   S00188 3317 27372 0
   S00371 3737 33636 0 
   S00371 3736 33635 0 
  </code></pre>