Skip to Content
avatar image
Former Member

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

    • Former Member

      Hello Amit,

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

  • Dec 14, 2017 at 01:56 PM

    Try this.

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

    Add comment
    10|10000 characters needed characters exceeded