Replace Function for Apostrophe character in the Report.net

[Rosti]

Hello all,
I am using report.net v8.2

When I am using replace function to remove ' character (apostrophe)it give me an error:

replace([Staff Last Name - MS], ''', 'another_string')

Please help!
Thank you!

 

[blom0344]

Did you try:

replace([Staff Last Name - MS], "'", 'another_string')

Ties Blom

 

[Rosti]

Hello. Yes, double qoutes (") are not accepted in the Report.net

 

[Rosti]

Hello,
good news - just found the answer - I need to use 4 single qoutes to find apostrophe:
replace([Staff Last Name - MS], '''', 'another_string')
It works!
Thank you!

 

[blom0344]

V8.2? Your are aware that this is Cognos8 and not ReportNet?

Ties Blom

 

[Rosti]

Yes. We are using 8.2 and 8.4, so sometimes I am confused. Thank you.

 

[blom0344]

Well, neither is ReportNet, which should be conclusive..

Ties Blom

 

[dslaster]

I have a problem similar to this. We just upgraded to Cognos 8.4.1 and this worked before in Cognos 8.1 MR 2. I want to select all names that don't contain an apostrophe. This is in my filter:

[Business View].[Constituent Person View].[ADDRESS_NAME] not like ''''

When I try to validate the report it just sits at the Validate with Report Server window with the hourglass spinning and never validates. If I run the report it never finishes.

Is there a different way to do this now? Thanks in advance for your help!

 

[blom0344]

[Business View].[Constituent Person View].[ADDRESS_NAME] =
replace([Business View].[Constituent Person View].[ADDRESS_NAME],'''','_')

assuming you use SQL server and have enabled vendor specific functions..

Ties Blom

 

[dslaster]

This worked! Thank you!