title: Deleting dynamic links from string
body: <p>In a Postgres database (9.3) I have strings like these from which I intend to delete the links:</p>
  
  <pre><code>'HV 3 STANKOVERLAST (+Inc,net: reg.inmeld+) , J.J. Cremerplein 46 AMSTERDAM [ ASD ] http:\/\/t.co\/qzmyMibvHn #p2000'
  'A1 13105 AMSTERDAM Bickersgracht 270 http:\/\/t.co\/4oX6B5oAo4 #p2000'
  'A1 13157 AMSTERDAM Argonautenstraat 54 3 http:\/\/t.co\/mmyjBcWEFY #p2000'
  'A1 13122 AMSTERDAM Tweede Helmersstraat 6 Hotel Crystal http:\/\/t.co\/BWGj4R1noh #p2000'
  </code></pre>
  
  <p>To delete them, I used:</p>
  
  <pre><code>split_part(text, 'http', 1)
  </code></pre>
  
  <p>Unfortunately, not all of them are build the same way with the link in the end:</p>
  
  <pre><code>'BR 2 BUITENBRAND (+http:\/\/t.co\/1x4jPyfA9e: reg.inmeld+) Ferdinand Bolstraat , Quellijnstraat AMSTERDAM [ ASD ] #p2000 #watiserloos'
  </code></pre>
  
  <p>Using <code>split_part()</code> here would delete big parts of this string</p>
  
  <p>I already looked for some kind of regex function, but couldn't find a solution for these dynamic links.</p>