Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
Tips and Tricks
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    NewStep=Table.TransformColumns(PreviousStepName,{"ColumnName",each Text.Combine(List.Select(Text.Split(_,";"),each Text.StartsWith(_,"PD-")),";")})

jennratten's avatar
jennratten
Icon for Super User rankSuper User
4 years ago

Hello - if you'd only like to keep rows that have a value beginning with 'PD-' in the 'Linked Issues - Copy' column, you can do it like this:

Table.SelectRows(#"Changed Type", each Text.StartsWith([#"Linked Issues - Copy"], "PD-"))