Need cognos 7 parallel function in cognos 8

[madhancog]

Hi Gurus,
  I am converting IQD files created in cognos7 to cognos 8 Query subject.
i am having Replace function in IQD how can i replace the same with cognos8 function.
ex. 
REPLACE(REPLACE("DIM_Phone"."Phone_Industry_name", ',' , ''), '/', '') "Phone_File_Name",


Thanks in advance,
K.M

[tupac_rd]

would decode function work

[rockytopmark]

Unfortunately, Cognos doesn't have a find/replace function like this, so you would have to leverage one from your Database's list of functions, or concoct one on your own using the substring() and position() functions.

replace() is actually a function in Oracle, so if your RDBMS is Oracle, you should be able to use it directly in your model.

[tupac_rd]

or try to upgrade the report/catalog from 7.4 to 8.x, and see what function Cognos would use....