title: Parsing url,hashtags out of twitter text
body: <p>I have already extracted all the tweets in csv file, I want to seperate twitter text from hashtags and urls, so far I have serarated the hashtags in excel using </p>
  
  <blockquote>
    <p>Data -> Text to Column</p>
  </blockquote>
  
  <p>First I don't know how to separate urls using this method
  Second is there a better way to do that? All the online links are separating both things at the time of scrapping</p>
  
  <pre><code>TEXT
  Learned a new concept today : metamorphic testing.  http:/t.co/0is1IUs3aW
  variant identification in pooled DNA using R http:/t.co/4PQfUaU
  Meta-All: a system for managing metabolic pathway information http:/t.co/2PfJXUxq2X
  </code></pre>
  
  <p>Here is what it should look like</p>
  
  <pre><code> TEXT                                                                 URL
    Learned a new concept today : metamorphic testing.                  http:/t.co/0is1IUs3aW
    variant identification in pooled DNA using R                        http:/t.co/4PQfUaU  
    Meta-All: a system for managing metabolic pathway information       http:/t.co/2PfJXUxq2X    
  </code></pre>
  
  <p>Right now both the text and url are in one column I want to put them in different columns</p>