Forum Discussion
GoingIncognito
6 years agoAdvocate III
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], ...
- 6 years ago
Hi GoingIncognito ,
You could use IF() and or/and to return your expected result.
Here is the similar case for your reference.
v-eachen-msft
6 years agoCommunity Support
Hi GoingIncognito ,
You could use IF() and or/and to return your expected result.
Here is the similar case for your reference.