Forum Discussion

RamiDaoud's avatar
RamiDaoud
Frequent Visitor
5 years ago

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...
Need Help
CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Hi, RamiDaoud , Text.Remove does the trick for you.

Table.AddColumn(Source, "Custom", each Text.Remove([Latitude], " "))

RamiDaoud's avatar
RamiDaoud
Frequent Visitor
5 years ago

I tried it but I recived the follwoing error: 

Expression.Error: The value isn't a single-character string.

Thank you