title: Filter records based on Text in Unix
body: <p>I'm trying to extract all the records that matches the text "IN" in the 10th field from this file.</p>
  
  <p>i tried  but it's not giving me the accurate results. Any help provided here would be highly appreciated.</p>
  
  <pre><code>awk '$10 == "IN" {print $0}'
  </code></pre>
  
  <p>input_file: my input file</p>
  
  <pre><code>A1|A2|A3|A4|A5|A6|A7|A8|A9|PK|A11|A13|A14|A15|A16|A17|A18
  1|2|3|4|5|6|7|8|9|IN|11|12|13|14|15|16|17|18
  AW|BW|CQ|AA|AR|AF|RR|AKL|ASD|US|PP|BN|TY|OL|Q3|M8|I7|V6
  AR|BR|CR|A8|AN|AQ|RU|A11|A13|IN|P9P|B0N|T2Y|O4L|Q43|M88|I71|V16
  </code></pre>
  
  <p>output_file: my output should be</p>
  
  <pre><code>1|2|3|4|5|6|7|8|9|IN|11|12|13|14|15|16|17|18
  AR|BR|CR|A8|AN|AQ|RU|A11|A13|IN|P9P|B0N|T2Y|O4L|Q43|M88|I71|V16
  </code></pre>
  
  <p>all the records that matched "IN" in the 10th field should be filtered. </p>