Forum Discussion

ValeriaBreve's avatar
ValeriaBreve
Post Partisan
2 years ago
Solved

List.FindText with items from a list?

Hello, I have 2 lists: ListData ListFilter both containing text strings. I would like to find any item in ListData that contains any part of a string from ListFilter. ex. ListData: {"red apple...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    2 years ago

    Another approach, using List.Accumulate to cycle through the ListFilter:

    let
    ListData= {"red apple", "blue apple", "green banana", "red pear"},
    ListFilter={"apple","pear"},
    filter = List.Accumulate(
        ListFilter,
        {},
        (s,c)=> s & List.FindText(ListData,c))    
in
    filter
ronrsnfld's avatar
ronrsnfld
Super User
2 years ago

There may be something wrong with how you implemented my solution.

Adding the item "2024 Q1" to ListData and "Q1" to ListFilter includes "2024 Q1" in the returned list.

 

 

let
    ListData= {"2024 Q1","red apple", "blue apple", "green banana", "red pear"},
    ListFilter={"apple","Q1"},
    filter = List.Accumulate(
        ListFilter,
        {},
        (s,c)=> s & List.FindText(ListData,c))    
in
    filter

 

 

Results (as expected):

 

 

 

ValeriaBreve's avatar
ValeriaBreve
Post Partisan
2 years ago

ronrsnfld ZhangKun Thanks! I don't know what was happening... I did a couple of transformations to the ListData - which change nothing to items like "2024 Q1" - and now it works. Never seen this before, and I don't understand it. Anyway - again thanks - with this it works perfeclty 🙂