Replace all instances within text string

[RyanSales]

Good day,

Just wondering if anyone can help with the code to do the following:

Search a text string for all instances of "XX" (we are actually looking for two capital X together, I'm not using XX to represent a variable!) and then format them with HTML.

Our goal is to simply search through the text field, find all XX and then have it come back bold and in a different colour.

Simple process, but actually very important for our project.

Thanks,
RY

 

[lbass]

Create a formula:

replace({table.string},"XX","<b><font color = red>XX</font color></b>")

Then right click on the formula in the detail section->format field->paragraph->text interpretain: HTML text.

-LB

 

[RyanSales]

Thank you so much. I'm assuming this will find/replace all instances of the XX?

Greatly appreciated!
RY