Forum Discussion
msantillan
6 years agoHelper II
Delimitter 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
- amitchandakSuper User