How to remove blank space

[Former Member]

Hello gurus,

I would like to ask you for your help. I have a problem with blank space, when I'm trying convert text to number. Results under "999" value are ok, but when I get for example "1 123", it shows Error. I tried remove spaces with =Replace function, but it's not working. It looks like the Webi knows, that there are "something", but not space. Is it possible to decode text in Webi or have you any other ideas?

Thank you

[amitrathi239]

Try this.

=ToNumber(Replace(Replace([Text];" ";"");",";"."))

[Former Member]

Hello, each value is error now. Have you any idea how to decode text? I think it could be useful for this problem.

[former_member310495]

Hi Donald,

Amit Kumar suggested formula working fine. Can u try with this formula for decimal values.

=ToDecimal( Replace( Replace([Value];" ";"");",";""))

Thanks,

Pavan Kumar Aurora.

[amitrathi239]

use this.

=ToNumber(Replace(Replace([Text];" ";"");",";""))

[Former Member]

Hello Amit,

Thank you for your response, but unfortunately there is still error and I need that number in decimal.