title: Replace multiple space with single space, Remove " and leading 0 using APACHE PIG
body: <p>Need help with PIG</p>
  
  <pre><code>A = load 'input.txt' as (line:chararray);
  B = foreach A generate FLATTEN(TOBAG(*));
  C = FOREACH B GENERATE REPLACE(($0, '\\s+', ' ')  
  </code></pre>
  
  <p>Need help on the last line to Replace multiple space with single space, Remove <code>"</code> (Quotes) and leading <code>00</code> using APACHE PIG</p>
  
  <p>Note:- Approach should NOT be field specific as there are more than 70 fields, 
   Basically, expecting help with REPLACE or STRSTRING OR REGEX function which can perfomr mentioned operations on a line.</p>
  
  <p><em>Input.txt</em></p>
  
  <pre><code>00595, ab 000cdef      california "state,   00USA
  00733, 0ds ds "ARIZONA 00state, USA
  </code></pre>
  
  <p><em>Expected Output</em></p>
  
  <pre><code>595, ab cdef califormia state, USA
  733, ds ds ARIZONA state, USA
  </code></pre>