Forum Discussion

msantillan's avatar
msantillan
Helper II
6 years ago
Solved

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.