Extracting From A Field with Multiple Delimiters

[shuhn1229]

Hi all,

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.

@ronrsnfld 

@AntrikshSharma 

Thanks

[jbwtp · Accepted solution]

Hi @shuhn1229,

This may help:

Table.AddColumn(#"Changed Type", "Calculated", each Text.Combine(List.Transform(List.Select(Text.Split([Input], "["), each Text.Contains(_, "]")), each Text.BeforeDelimiter(_, "]")), ", "))

Cheers,

John

[lpetty421]

Thanks John!!!!  Yours was the best answer of all!!!!!

[lpetty421]

Excellent!!!!!

[shuhn1229]

looks like it's working great! you the man (or woman!)