title: Get xml Values in Pig Latin
body: <p>I am using pig latin for a large XML dump. I am trying to get the value of the xml node in pig latin. The file is like</p>
  
  <p>&lt; username>Shujaat&lt; /username></p>
  
  <p>I want to get the input Shujaat. I tried piggybank XMLLoader but it only separates the xml tags and its values also. The code is </p>
  
  <pre><code>register piggybank.jar;
  
  A = load 'username.xml' using org.apache.pig.piggybank.storage.XMLLoader('username')
  as (x: chararray);
  
  B = foreach A generate x;
  </code></pre>
  
  <p>This code gives me the username tags also and values too. I only need values. Any idea how to do that? I found out regular expression but didnt know much?
  Thanks</p>