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
Icey's avatar
Icey
Community Support
5 years ago

Hi RamiDaoud ,

 

Is this problem solved?

 

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If not, please share us a dummy .pbix file with the same issue. Please remove real data and sensitive information.

 

 

Best Regards,

Icey

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]), " "))