3

So I'm trying to do the following: A column in my table contains a bunch of text, amongst which is --

<a href="random.website.com>Text I want to keep</a>

which I want to change to:

Text I want to keep

Do also note that "random.website.com" is basically unique for each item, i.e.: it contains a different link for each item.

I am aware that there is a third party UDF called REGEXP_REPLACE but this is not available for me to use.

Is there any other to accomplish this? Appreciate any help of course.

Regards

René Kuhs
  • 31
  • 1
  • You can write a script to change them. can you run php? – Samurai Jul 19 '13 at 18:43
  • Perhaps you would find this [related question](http://stackoverflow.com/questions/2627940/remove-html-tags-from-record) to be useful. – Air Jul 19 '13 at 20:05

0 Answers0