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

Power BI APP - Delete or Unpublish

 UNPUBLISH DELETE