Crystal Reports 2008, In a formula, how do I replace multiple strings with a database field?
I have a database string that appears as follows:
The <%7%> jumped over the <%moon%> and laughed at the <%5%>.
I have a database table that contains values as follows:
I am trying to figure out in a Crystal Reports formula, how to swap out only numeric values that land inbetween the “<%” and “%>” tags. Any characters that land inbetween the two tags should be left alone.
The final result above would look as follows:
The <%Cow%> jumped over the <%moon%> and laughed at the <%Dog%>.