Find replace in crystal? 3

[Thant]

I have a report im trying to build where one field is given as a code "ME01 ME02" etc. and then we have to translate those fields into activities ME01= prescribing error ME02=omission error etc. What I would like to do is build a formula that will search the report and when it sees ME01 in a certain field it will replace it with the text "prescribing error". I know there has to be a way to do this but I am not a programmer and cannot figure out a good way.

Thank you

 

[IdoMillet]

Create a formula such as:
--------------------------
Select {Your_Table.Your_Field}
Case "ME01":
"prescribing error"
Case "ME02":
"omission error"
Default:
"unknown error";
--------------------------

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Thant]

This works! Thanks You've taught me something new and I appreciate it