title: I want to extract specific information from XML input using Hadoop Pig Latin
body: <p>Expected output is: <code>(Hadoop definitive guide,Tom white,24.90)</code>.</p>
  
  <p>I have tried using the <code>Regex_Extract()</code> function. But, no luck yet. Can someone please help me out?</p>
  
  <p>The input to my script is:</p>
  
  <pre><code>&lt;CATALOG&gt;
  &lt;BOOK&gt;
  &lt;TITLE&gt;Hadoop DEFINITIVE GUIDE&lt;/TITLE&gt;
  &lt;AUTHOR&gt;TOM WHITE&lt;/AUTHOR&gt;
  &lt;COUNTRY&gt;US&lt;/COUNTRY&gt;
  &lt;COMPANY&gt;CLOUDERA&lt;/COMPANY&gt;
  &lt;PRICE&gt;24.90&lt;/PRICE&gt;
  &lt;YEAR&gt;2012&lt;/YEAR&gt;
  &lt;/BOOK&gt;
  &lt;BOOK&gt;
  &lt;TITLE&gt;Programming Pig&lt;/TITLE&gt;
  &lt;AUTHOR&gt;Alan Gates&lt;/AUTHOR&gt;
  &lt;COUNTRY&gt;USA&lt;/COUNTRY&gt;
  &lt;COMPANY&gt;Horton Works&lt;/COMPANY&gt;
  &lt;PRICE&gt;30.90&lt;/PRICE&gt;
  &lt;YEAR&gt;2013&lt;/YEAR&gt;
  &lt;/BOOK&gt;
  &lt;/CATALOG&gt;
  </code></pre>