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!
I have a formular working thus far -
Replace({CFG8ORDER.STATUS}
That works fine, what I need to do is add exactly the same but as this -
Replace({CFG8ORDER.STATUS}
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!
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)
Replace(Replace({CFG8ORDER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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. :(
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. :(
ASKER
Superb! Thanks for that, worked a treat!