I have tried doing this:
REPLACE(string, "<*>", "").
but it doesn't seem to work.
", ""). but it doesn't seem to work." /> ", ""). but it doesn't seem to work." /> ", ""). but it doesn't seem to work."/>
I have tried doing this:
REPLACE(string, "<*>", "").
but it doesn't seem to work.
Copyright © 2021 Jogjafile Inc.
REPLACEdoesn't work like that. There's no wildcard matching in it.I've included a simple way of doing this below. However, there's lots of cases that this wont work in - non well formed html etc. But perhaps you can start here and move forward by yourself.
What I do is look for < and > in the text and replace everything between it with a pipe (|) (you could select any character - preferably something not present in the text. When that's done all pipes are removed.
Again, this is a quick and dirty solution and not safe for production...