Delimitter Text with or condition Power Query

[msantillan]

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.

[amitchandak · Accepted solution]

@msantillan , refer if this can help  https://stackoverflow.com/questions/39325985/power-bi-query-extract-text-between-delimiters-to-a-new...