How to remove &nbsp from report

myintw · Post by **myintw** » Fri May 20, 2011 7:35 am

Hi,

I want to remove &nbsp from my rtf report. In my report, I get value from GridView and export it to rtf. The problem I have in my report is, null value or blank/no value is filled by &nbsp. For instance,

I would like to display like:

Company| Address | Contact | Country | Email
AAA LA 989877 USA aa@AAA.com
BBB CA 879989 bb@BBB.com
CCC 889977 cc@CCC.com

In my report is like:

Company | Address | Contact | Country | Email
AAA LA 989877 USA aa@AAA.com
BBB CA 879989 &nbsp bb@BBB.com
CCC &nbsp 889977 &nbsp cc@CCC.com

Could you please tell me how to remove this &nbsp from my report and just display blank instead of this. I tried with Text.Trim(); But it doesn't work. Any idea, to solve this out, please. Thanks in advance to Stimulsoft team.

Regards,
Win

Post by **Alex K.** » Mon May 23, 2011 12:42 am

Hello,

As a way, you can try to use the following expression:
DataSource.Column.Replace("&nbsp", "")

Thank you.

myintw · Post by **myintw** » Tue May 24, 2011 7:00 am

Hi Aleksey,
Thanks, I tried the way you said and it worked.

Cheers

Post by **Andrew** » Tue May 24, 2011 1:04 pm

Hello,

Perfect.

Have a nice day!
Thank you.