Forum Discussion

RappJ's avatar
RappJ
Helper I
4 years ago
Solved

each not Text.Contains is not working

Good day all,

Any idea why this filter will not work? Screenshot is with filter applied.  Am I misunderstanding how this filter should work? Is it case sensitive and can that be ignored?

 

= Table.SelectRows(#"Filtered Rows", each not Text.Contains([Description], "CAP"))

 

 

Thank you.

 

Need Help
  • RappJ's avatar
    RappJ
    4 years ago

    Fixed.
    = Table.SelectRows(#"Filtered Rows", each not Text.Contains([Description], "upg",Comparer.OrdinalIgnoreCase) or not Text.Contains([Description], "cap",Comparer.OrdinalIgnoreCase))

2 Replies

  • RappJ's avatar
    RappJ
    Helper I
    4 years ago

    Fixed.
    = Table.SelectRows(#"Filtered Rows", each not Text.Contains([Description], "upg",Comparer.OrdinalIgnoreCase) or not Text.Contains([Description], "cap",Comparer.OrdinalIgnoreCase))