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))