Link to home
Start Free TrialLog in
Avatar of Prefuse
Prefuse

asked on

Using replace in crystal reports

Hello, I am trying to use repalce in crystal reports to replace two tex values with two others.

I have a formular working thus far -

Replace({CFG8ORDER.STATUS}, "QUOTE","Entered",1,-1,0)

That works fine, what I need to do is add exactly the same but as this -

Replace({CFG8ORDER.STATUS}, "LINKED","Spun",1,-1,0)

If I use the and commnad add the above text the formular errors.

I am not sure how to get the formular in to one row?

Thanks!
Avatar of Meir Rivkin
Meir Rivkin
Flag of Israel image

i don't think u can perform multiple replace string text in a single line, you got have it deparated lines.
Try...
Replace(Replace({CFG8ORDER.STATUS}, "LINKED","Spun",1,-1,0) "QUOTE","Entered",1,-1,0)
ASKER CERTIFIED SOLUTION
Avatar of kingjely
kingjely
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Prefuse
Prefuse

ASKER

That didn't work, it errors saying ) is missing and highlights the QUOTE text?

The problem with having two formula for each occasion is having to have two formula on the details section, they will both show on the report a seperate entities. I need a combined output result. :(
Avatar of Prefuse

ASKER

Superb! Thanks for that, worked a treat!