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

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.

You will need a Custom Function for this.

Or not.

HTMLtags.fp7.zip

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

You are tremendous!!

That is absolutely perfect.

Many, many thanks.

DSW