title: Filter a string on the basis of a word
body: <p>I have a pig job where in I need to filter the data by finding a word in it,</p>
  
  <p>Here is the snippet</p>
  
  <pre><code>A = LOAD '/home/user/filename' USING PigStorage(',');
  B = FOREACH A GENERATE $27,$38;
  C = FILTER B BY ( $1 ==  '*Word*');
  STORE C INTO '/home/user/out1' USING PigStorage();
  </code></pre>
  
  <p>The error is in the 3rd line while finding C,
  I have also tried using</p>
  
  <pre><code>C = FILTER B BY $1 MATCHES '*WORD*'  
  </code></pre>
  
  <p>Also</p>
  
  <pre><code>C = FILTER B BY $1 MATCHES '\\w+WORD\\w+'  
  </code></pre>