title: PIG latin-- Special Character handling - Å -- capital A with ring above
body: <p>I want to check if a column contains some set of special characters and do evaluation further, I was able to do it for most of the spl chars but not for one particular spl character. Has anyone come across and handled this spl char- Å? I even used backslash to escape it but in vain, as seen in the code below.</p>
  
  <hr>
  
  <pre><code>    --
      t1 = LOAD '$input_track1' using PigStorage('|') as (t1data:chararray,           sec_col:int);
      t1_output = foreach t1 generate $0, (CASE WHEN SUBSTRING($0, 0, 1) IN ('F','S') THEN 1 ELSE 0 END) AS ORR,
     (CASE WHEN SUBSTRING($0, 0, 1) IN ('^','@', '|','[',']','-','`','{','}','~','!','#','$','%','&amp;','(',')','*','&lt;','&gt;',':','=','?', '"','\'''\Å')      THEN 1 ELSE 0 END) AS ORR2;
   dump track1_output;
  </code></pre>
  
  <p>Sample data:</p>
  
  <p>ÅSecond|456</p>