Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Repetitive Nonbreak space

Hello Community, Now I have a strange problem, in some columns I'm not able to change values type to decimal (1.2) : The problem is the thousands values looks like this "1 000". I thought it is a sp...
Need Help
spinfuzer's avatar
spinfuzer
Solution Sage
2 years ago

Maybe try removing anything that isn't a "-", "," or number?  Replace Column1, Column2, and Column3 with your column names.

 

 

 

let
    priorStep = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    clean = 
            Table.TransformColumns(
            priorStep,
            List.Accumulate(
                {"Column1","Column2","Column3"},
                {},
                (state,current) => state & {{current, each Number.From(Text.Combine(List.Select(List.Buffer(Text.ToList(_)), (T) => try Value.Is(Number.From(T), type number) otherwise T = "-" or T = ","))), type number }}
            )
            )
in
    clean