I am relatively new to power query and am trying to extract all the text between [] delimiters in a field, if they exist. See example below:
Input
Output
[Apples] - 46 [Oranges] -1
Apples, Oranges
[Oranges] -1
Oranges
I need some fruit
The problem I am running into is the delimeters between text in the ribbon is only returning one delimeter. I looked into this with this awesome thread, but I can't wrap my head around using "[" and "]" to begin and close the delimiters, respectively.
Table.AddColumn(#"Changed Type", "Calculated", each Text.Combine(List.Transform(List.Select(Text.Split([Input], "["), each Text.Contains(_, "]")), each Text.BeforeDelimiter(_, "]")), ", "))
Table.AddColumn(#"Changed Type", "Calculated", each Text.Combine(List.Transform(List.Select(Text.Split([Input], "["), each Text.Contains(_, "]")), each Text.BeforeDelimiter(_, "]")), ", "))
