title: Print a Row only if the String exist in a specific Column
body: <p>Need help on an awk (or sed) command to select a row only if the Value/String Exist in a specific Column.</p>
  
  <p>Example:</p>
  
  <p>I only want to return the row if the word 'true' exist in column 5, do not bring the row back if 'true' does not exist in column 5</p>
  
  <p>input:</p>
  
  <pre><code>john,jacob,jingle,schmidt,true
  jason,jack,john,true,false
  oscar,meir,true,weiner,false
  tiffany,amber,false,theissen,true
  jack,john,sally,true,true
  </code></pre>
  
  <p>Desired Output:</p>
  
  <pre><code>john,jacob,jingle,schmidt,true
  tiffany,amber,false,theissen,true
  jack,john,sally,true,true
  </code></pre>
  
  <p>I know how to 
  pull a row back that has a word and doesnt have a word like this:</p>
  
  <pre><code>awk '/true/ &amp;&amp; !/false/'
  </code></pre>
  
  <p>but that wont work
  and I know how to remove a word only if its in a specific column</p>
  
  <pre><code>awk 'BEGIN{FS=OFS=","} {sub(/true */, "", $5)} 1'
  </code></pre>
  
  <p>but I do not know how to combine these two. </p>
  
  <p>my best guess is:</p>
  
  <pre><code>awk 'BEGIN{FS=OFS=","} {"/true/",$5}
  </code></pre>
  
  <p>worst case scenario....:)</p>
  
  <pre><code>awk 'BEGIN{FS=OFS=","} {sub(/true */, "Unmatchablestring", $5)} 1' | awk '/Unmatchablestring/'
  </code></pre>