Tuesday, May 26, 2020

Power Query - Remove letters from a string

Line = Table.AddColumn(PrevLine, "NewVar", 
each Text.Combine(List.RemoveNulls(List.Transform(Text.ToList([OldVar]),
each if Value.Is(Value.FromText(_), type number) then _ else null))))

No comments:

Post a Comment

SQL - Query Analytics Basic

  SELECT Nome_Produto, ROUND(MIN(Valor_Venda), 2) AS Valor_Minimo, ROUND(MAX(Valor_Venda), 2) AS Valor_Maximo, ROUND(AV...