Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Text.BetweenDelimiters function, bug or user error?

Greetings all, I’m nesting the Text.BetweenDelimiters function within a Text.Select function and I’m getting a result that looks wrong. It looks like the BetweenDelimiters function is not working pr...
Need Help
  • mussaenda's avatar
    mussaenda
    3 years ago

    Hi Anonymous ,

     

    Then nest your formula with if Text.Contains functions.

     

    Like if the Event Title contains "-" and "(" then your nested  formula else, null

    You think that will work for you?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

mussaenda 

 

🎉😊👏🎉

= Table.AddColumn(#"Changed Type1", "Container ID", each

            if Text.Contains ([Event Title], "-") and Text.Contains ([Event Title], "(") then
                Text.Select
                      (Text.BetweenDelimiters([Event Title], "-", "(" ),
                {"a".."z", "A".."Z", "0".."9"})
           else null)