Skip to Content
0

How to remove blank space

Dec 14, 2017 at 09:35 AM

44

avatar image
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

blank-space.png (2.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Dec 14, 2017 at 10:48 AM
0

use this.

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Amit,

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

0
AMIT KUMAR
Dec 14, 2017 at 01:56 PM
0

Try this.

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
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.

0

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.

solution.png (44.4 kB)
0