Forum Discussion
msantillan
Helper II
6 years agoDelimitter Text with or condition Power Query
Anyone knows how to create an or condition for Delimitter text on M query?
I have this code:
Text.BetweenDelimiters([Labels], "BUG_", "_MNL")
which helps me find the Text between "BUG_" and "_MNL", however I want to have 3 or conditions for the First part.
I tried this code, but it didn't work:
Text.BetweenDelimiters([Labels], "BUG_" or "BAU_" or "ENH_", "_MNL")
Basically I want the text between "BUG_" or "BAU_" or "ENH_" and "_MNL"
Thank you.
1 Reply
- amitchandak
Super User