How do I replace a hyphen with a blank ?

[#1]

Hi All,

I have a text object on a dashboard which displays a Country field thus, =[Country]

However, if the country value doesn't exist, or is not applicable to the selection then a hyphen is displayed -

How can I replace the hyphen in this instance with a blank space ?

Thanks in anticipation

MV

[#2]

On Chart Properties->Presentation Tab ->replace the hyphen in null symbol and missing symbol by space

[preminqlik · Accepted solution]

=if(isnull(Country),' ',Country)

[#4]

Use the Function Alt,

alt(Country,' ')

Regards,

Prabhu

[ferha_jafri]

right click-properties-presentation then remove null symbol - and missing value - with blank and you will get it by removing the hyphen put a space and hit enter you will get blank.

[#6]

Hi,

I'm confused. A text object doesn't have a Presentation tab. And I can't find the null symbol you're talking about either !

[#7]

Just what I wanted. Thank you !