Help needed using REPLACE function

Post Author: Domo

CA Forum: Formula

I need to swap out HTML special characters for their corresponding symbols.

The text field in question obviously contains many number codes, e.g. ' for an apostrophe (') and I would like to write a formula which replaces these for it's corresponding text character.

How would I go about this? I know how to use replace for single entries, e.g. Replace(, "'", "'"); but how do I apply this to multiple entries?

I have been using Crystal syntax for other formulas in the report (not sure if Basic and Crystal can be used?).