title: Splitting a string in Pig in a column and then storing it in a row
body: <p>I have a csv file which contains 4 columns of data but has 250000 rows. </p>
  
  <pre><code>A          B      C     D               
  Tom        1      x    Blah Blah Blah
  Bob        2      y    Blah &lt;p&gt; Blah
  Jane       3      z    Blah, &amp;p *£
  Harry      4      a    Blah "p" Blah
  </code></pre>
  
  <p>In col 4 I have a string that contains a variety of characters, some code, some special characters, some text. </p>
  
  <p>I would like to take each word in D and combine it with the contents in A and store it in a new row i.e</p>
  
  <pre><code>Tom Blah
  Tom Blah
  Tom Blah
  Bob Blah
  Bob &lt;p&gt;
  Bob Blah
  Jane Blah,
  Jane &amp;p
  Jane *£
  Harry Blah
  Harry "p"
  Harry Blah
  </code></pre>