Forum Discussion

ValeriaBreve's avatar
ValeriaBreve
Icon for Post Partisan rankPost Partisan
3 years ago
Solved

Filter a list by any matching string from another list

Hello, I have a table with certain columns names, and I would like to remove some containing a defined string.   An example below where I only used a string "budget" as I am not sure how to do it ...
Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    Hello, ValeriaBreve I made it case insensitive. If you don't want that - remove comparer. 

    let
    ListTextToBeRemoved={"Plan","budget"},
    column_names = {"2023 plan", "2023 budget", "2024 fact", "2023 fact", "222 BUDGET"},
    ColumnstoBeRemoved = 
        List.Select(
            column_names, 
            each 
                List.ContainsAny(
                    {_}, 
                    ListTextToBeRemoved, 
                    (x, y) => Text.Contains(x, y, Comparer.OrdinalIgnoreCase)))
in
    ColumnstoBeRemoved

     

     

     

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

ColumnstoBeRemoved=List.Select(Table.ColumnNames( #"Changed Type"), each List.Contains(ListTextToBeRemoved,_,(x,y)=>Text.Contains(y,x)))