Apostrophe Not Recognized

[Quan Tran 4]

I have created a cross table in Spotfire. In the Data tab of the Properties, I have put Entity="Saint Mary's Hospital" in the Limit data using expression:. This does not return any data even though there are records with "Saint Mary's Hospital." I tried using other Entities that do not have the apostrophe and they worked fine. Is this an escape character issue I have tried the following without success: [Entity]="Saint Mary's Hospital" "Saint Mary%60s Hospital" "Saint Mary%27s Hospital" "Saint Mary/'s Hospital" "Saint Mary's Hospital" "Saint Mary"+"%60"+"s Hospital" "Saint Mary"&"%60"&"s Hospital" Concatenate("Saint Mary", %27, "s Hospital") Concatenate("Saint Mary", "'", "s Hospital") Concatenate("Saint Mary", "/'", "s Hospital") Concatenate("Saint Mary", "'", "s Hospital") Concatenate("Saint Mary", ""'"", "s Hospital") "Saint Mary""'""Hospital" "Saint Mary"'"s Hospital" RXReplace("Saint Mary\s Hospital","\\","'","") RXReplace("Saint Mary\s Hospital","\\",%27,"") "Saint Mary's Hospital" "Saint Mary"&"'"&"s Hospital" "Saint Mary"+"'"+"s Hospital" "Saint Mary"&""'""&"s Hospital" "Saint Mary"+""'""+"s Hospital" "[saint Mary's Hospital]" ["Saint Mary's Hospital"]

[Gaia Paolini]

Hi

it works for me without changing anything. Maybe it is a different character.

Can you upload an example

Gaia

[Quan Tran 4]

Thank you for your response. The filter was set to exclude"Saint Mary's Hospital" which is why no records were returned.