Skip to Content

How to remove blank space

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

blank-space.png (2.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 14, 2017 at 10:48 AM

    use this.

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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 14, 2017 at 01:56 PM

    Try this.

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

    Add comment
    10|10000 characters needed characters exceeded