Forum Discussion
RamiDaoud
5 years agoFrequent Visitor
Remove White Spaces between decimal digits
Hello, I have Latitude column with Decimal type and there are some spaces between the digits. My question is how I can remove the spaces? . I tried trim function which required changing the type fro...
Jimmy801
5 years agoCommunity Champion
Hello RamiDaoud
are you sure the second parameter is a " " and not a string with 2 characters?
BR
Jimmy
RamiDaoud
5 years agoFrequent Visitor
Thank you for your comment I modified it based on your comment. However, I recived the following error:
Expression.Error: We cannot convert the value 32.346477999999998 to type Text.
Details:
Value=32.346478
Type=[Type]
- Jimmy8015 years agoCommunity Champion
Hello
Then surround your column reference with Text.From()
Br jimmy