Forum Discussion
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...
Hi, RamiDaoud , Text.Remove does the trick for you.
Table.AddColumn(Source, "Custom", each Text.Remove([Latitude], " "))
I tried it but I recived the follwoing error:
Expression.Error: The value isn't a single-character string.
Thank you
Hello RamiDaoud
are you sure the second parameter is a " " and not a string with 2 characters?
BR
Jimmy
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]Hello
Then surround your column reference with Text.From()
Br jimmy
