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
ValeriaBreve's avatar
ValeriaBreve
Post Partisan
2 years ago

ronrsnfld  ZhangKun both your solutions work but only partially for me (which I know it's impossible). Still In my filter list I have items like "Q1". In my data list I have an item "2024 Q1" and it won't be returned. I checked the spelling, no trailing spaces...do you have an idea what might be happening? Thanks!

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 🙂