Forum Discussion
Text.Startswith() with plural strings
Hi.
How do I accomplish - using M - excluding all strings that begin with "xyz", "ab", any number, etc.
It would be something like =Table.SelectRows(#"last step", each Text.StartsWith([column], "") = false ) ?
Inserting false would exclude all the values? But how do I replace "" with a list of values?
Thank you!
Hi GoingIncognito ,
You could use IF() and or/and to return your expected result.
Here is the similar case for your reference.
4 Replies
I did actually look at it before postin a question because I thought my case is such an easy scenario that you could just insert a List.Contains or something in my example and make it work? Or am I completely wrong? Thank you for the link and all!
Hi GoingIncognito ,
Has your problem been solved? If the problem has been solved, you could accept the reply you like.
Hi GoingIncognito ,
You could use IF() and or/and to return your expected result.
Here is the similar case for your reference.
