Removing HTML tags using a function

Hi,

I am trying to remove html formatting tags from data that is already in a table on the db. The data is used, with the formatting, to display on a web page but I also want to use the same data to output to a spreadsheet using the php functions for that task.

Both of the above work well except that I cannot remove the tags for the spreadsheet output so the <p> <br> etc show in the file. I tried php's strip_tags() function on the php side of things but that did not work.

I have tried using a sql function found here on the forum id 24766 (sorry cannot post a link yet)

but when I run it I get the following error - attached.

Any advice would be very welcome, thank you

(Heidi Version 10.1.0.5464 (64bit))

Here's the link to your mentioned thread

Thank you Ansgar