Calc: TextStyleAdd() for <tags>

[ori_wel]

In my web site, users can submit text along with the bold, underline, and italics html tags.

i.e. [b]Some[/b] text like [u]this[/u]

I need to create a calculation field translates the html tags into actual formatted text.



I propose to use:

Substitute( text ; [b]substring[/b] ; TextStyleAdd( substring ; Bold ) )

However, I do not know how to isolate the substring, particularly when there might be multiple instances within the same text field.

Any advice would be much appreciated. Thanks in advance!

DSW

[-Queue-]

You will need a Custom Function for this. You may be able to find one already created for this purpose at Brian Dunning's site.

[comment]

You will need a Custom Function for this.

Or not.

HTMLtags.fp7.zip

[-Queue-]

Good point. I was thinking you would need to include the in-between value in the substitution as well.

[ori_wel]

You are tremendous!!

That is absolutely perfect.

Many, many thanks.

DSW