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
RamiDaoud's avatar
RamiDaoud
Frequent Visitor
5 years ago

Hello,

Unfortunatly, the problem has not been solved yet. I will share the file soon. 

Thanks,

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

RamiDaoud , as Jimmy801 mentioned, embedded Text.From() function will do the trick,

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