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?).