title: Matching a column against multiple possible values
body: <p>I am trying to use <code>awk</code> to filter out data from a file. As of now, for a single value I am using the command like the below</p>
  
  <pre><code>hadoop fs -text file:///a/b/filename.snappy  awk -F'|'  '$11 == 655' &gt; filter_20180705.txt
  </code></pre>
  
  <p>I want to pass a list of values in comparison section, instead of passing <code>$11 == 655</code>, I would like to pass a list like <code>$11</code> IN (list). Any thoughts on this will be helpful</p>
  
  <p>Sample-data:</p>
  
  <pre><code>karthick,bangalore,software,it,bfsi,spark,hadoop,bigdata,etl,pentaho,655,dev
  kumar,bangalore,software,it,bfsi,spark,hadoop,bigdata,etl,pentaho,611,dev
  Raj,bangalore,software,it,bfsi,spark,hadoop,bigdata,etl,pentaho,800,dev
  John,bangalore,software,it,bfsi,spark,hadoop,bigdata,etl,pentaho,823,dev
  </code></pre>
  
  <p>As of now I am getting the result as </p>
  
  <pre><code>karthick,bangalore,software,it,bfsi,spark,hadoop,bigdata,etl,pentaho,655,dev
  </code></pre>
  
  <p>I will need pass a list in the comparison filter. For example, I want to add <code>611</code> and <code>823</code>. So the expected result would be </p>
  
  <pre><code>karthick,bangalore,software,it,bfsi,spark,hadoop,bigdata,etl,pentaho,655,dev
  kumar,bangalore,software,it,bfsi,spark,hadoop,bigdata,etl,pentaho,611,dev
  John,bangalore,software,it,bfsi,spark,hadoop,bigdata,etl,pentaho,823,dev
  </code></pre>