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))))

Power Query - funcao limpa replace texto numero

//fnc_limpa_texto (TextValue as nullable text) => let     SafeText = if TextValue = null then "" else TextValue,     DigitsOnly...