ReplaceBetween function only replaces first occurrence of the searched string

1

Seems to replace only the first occurrence of the string when the value contains multiple instances of the same search string. Would you be able to enhance this function as follows?

I don't want to remove all the html tags - if the sanitize action would allow for specifying specific attrbutes to keep/remove that might work as well.

Or is there a different solution as I'm never sure what all the properties will be for each element.

replacebetween([Column],"<font ","",">")

image
image1480×323 35 KB

2

Hi @CTN,

We will consider adding options to ReplaceBetween/KeepBetween to match All/N occurrences instead of just one.

For now, you can use regexreplace with an appropriate pattern. Something like:
regexreplace([Column], "<font>", '<font\b[^>]*>')
may work to remove all attributes from <font> tags. Other patterns may better fit your specific use case.