title: How to filter on CSV data using filter on multiple columns
body: <p>I have following data set in csv and would like to filter this on multiple columns using awk (My Version is GNU 3.1.7)</p>
  
  <p><strong>How can i use awk to filter on multiple columns</strong> </p>
  
  <p>i used following command but didn't give required result.</p>
  
  <pre><code>awk -F, '{ if ($7="3YM62AE#UUS" &amp;&amp; $5="01CS") print $1","$2","$3","$4","$5","$6","$7","$14}' file1.csv &gt; file2.csv
  </code></pre>
  
  <p>Let me know if i am using correct awk command.</p>
  
  <p><a href="https://i.stack.imgur.com/BWFP1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BWFP1.png" alt="enter image description here"></a></p>