Change text color in Long field

[cbriell]

I apologize for a repeat post, but I was hoping to get some additional info from a previous post (thread767-1146037).

I am on Crystal XI sp2 and Oracle 8.17. We have a long(memo) field that I would like to change the color of a keyword. Here is my formula:

replace({RESULT_TEXT.LONG_RESULT_VALUE},"Syncope","<font color=red>Syncope</font>")

How do I take into account other spellings of the word? Can I make it case insensitive? I tried putting in an "and/or" statement but it then becomes a boolean formula. I wasn't sure how to create proper statement to fullfil the boolean.

Thank you for all the help you have provided. I have gotten so much knowledge from this forum.

Chris

 

[cbriell]

One additional question...Do you have to use the HTML? The field loses the carriage returns in the HTML format.

 

[lbass]

To address the case issue, you could do this:

replace(ucase({RESULT_TEXT.LONG_RESULT_VALUE}),"SYNCOPE","<font color=red>Syncope</font>")

To address other spellings, you could nest the statement, as in:

replace(ucase(replace(ucase({RESULT_TEXT.LONG_RESULT_VALUE}),"SYNCOPE","<font color=red>Syncope</font>")),"SINCOPE","<font color=red>Syncope</font>")

-LB