Forum Discussion
Issues with removing data in column using Text.remove
Hi all, I’ve spend a lot of time in fixing the error (youtube, this forum). What i did?: I’ve imported a table into excel, for which I want to transform (delete) data with power query. I only wa...
NewStep=Table.TransformColumns(PreviousStepName,{"ColumnName",each Text.Combine(List.Select(Text.Split(_,";"),each Text.StartsWith(_,"PD-")),";")})
wdx223_Daniel
Community Champion
Community ChampionNewStep=Table.TransformColumns(PreviousStepName,{"ColumnName",each Text.Combine(List.Select(Text.Split(_,";"),each Text.StartsWith(_,"PD-")),";")})
Thanks this did the job!